eric_verhorstert
Explorer
Member since ‎04-11-2013

User Statistics

  • 49 Posts
  • 1 Solutions
  • 0 Kudos given
  • 0 Kudos received

User Activity

SQL Anywhere version 12.0.1.3797 I have a performance problem with one of the databases. The query has about 30 "left outer joins" to stored procedures. For this report about 10 tables are involved with about 2.000.000 rows per table. Database i...
We have created a .Net assembly with Powerbuilder 12.5.1 build 4541.This .NET assembly is used in a c# program.When we try to save data to a SQL anywhere database using a datastore we get error.System.AccessViolationException was unhandled HResult=...
SQL Anywhere 12.0.1.3797We use the "Synchronize profile" statement to upload data to our consolidated database. On one computer we have a problem, the upload is not starting. When we use the program dbmlsync.exe there is no problem. When we copy the ...
An external program is dumping .xml files in a folder.As soon as the file is dumped we should import it in our SQL anywhere 12 database and move this file to a other folder.We do not know the names of the external files but the extension is allways ....
A part of a function in our database looks like this:while @datecount <= today() loop    set @datecount = dateadd(day, 1, @datecount);    insert into gt_datetable( countdate ) values ( @datecount );end loop; We have to insert about 200000 records in ...