FiveTech Software tech support forums

... test (campo1,campo2) values ('1','texto1'),('2','texto2') and no error. But like Rao said, Informix does not support. We need to do single row inserts only. Statements UNLOAD TO and LOAD FROM are not standard SQL statements and they are part only in IMB DbAccess I fond this on IBM info center ...

... and no error. My table test structure: campo1 numeric campo2 text Can you put here your error ? Best regards Many servers support multiple row inserts this way or similar way. (Note: FW_AdoImportFromDBF() uses the syntax appropriate for different servers using multiple row insert statements) ...

Mr Tim and Mr Ortiz In the next version, we propose to include export function based on bulk inserts which are ten times faster than the present export function. To start with they will work for text only data for MySql and MSSql only. While you may test the present functions, ...

... 3 65 Row Undo Delete Notification 3 66 Row Undo Insert Notification 3 67 Row Update Notification 3 68 Bookmarks Ordered VERDADERO 69 Others' Inserts Visible FALSO 70 Others' Changes Visible FALSO 71 Own Inserts Visible VERDADERO 72 Own Changes Visible VERDADERO 73 Quick Restart VERDADERO ...

... 3 65 Row Undo Delete Notification 3 66 Row Undo Insert Notification 3 67 Row Update Notification 3 68 Bookmarks Ordered VERDADERO 69 Others' Inserts Visible FALSO 70 Others' Changes Visible FALSO 71 Own Inserts Visible VERDADERO 72 Own Changes Visible VERDADERO 73 Quick Restart VERDADERO ...

... as an administrator. If any one can help, i would be very grateful as i do not see what can be wrong. I join the fw code and a small php that inserts records into the tbale , this one works OK The code can be executed , tested with Harbour and xharbour same result. Thanks for help Richard ...

... http://bugs.mysql.com/bug.php?id=42316 Thanks for the information. However its somewhat comforting that clientside recordsets are working well and inserts are working well. In the case of MSAcess can you take the trouble of doing this test? oRs:AddNew( { "test" }, { 12.50 } ) and then ...

... these as "SQL scripts". Here is one such (multi-statement) script I'm currently executing against an ADS server. You will find several Inserts, Updates, Merge as well as sql code syntax:   //This sql will fetch and post records from remit into payfile    //after that, it sets isPosted ...

... CODIGO Type Numeric and lenght 6. I have another table with one field named NEXTCUS Type Numeric and lenght 6, i use this field to control the inserts. All the time that i insert one registry in customer table i lock this field and add +1 to NEXTCUS, save and unlock. OK, remember that locking ...

... CODIGO Type Numeric and lenght 6. I have another table with one field named NEXTCUS Type Numeric and lenght 6, i use this field to control the inserts. All the time that i insert one registry in customer table i lock this field and add +1 to NEXTCUS, save and unlock. OK, remember that locking ...

... CODIGO Type Numeric and lenght 6. I have another table with one field named NEXTCUS Type Numeric and lenght 6, i use this field to control the inserts. All the time that i insert one registry in customer table i lock this field and add +1 to NEXTCUS, save and unlock. I use this because dbf ...

... 20]: This function used SQL "INSERT" statements to speed up import instead of ADO's AddNew(). Though MSACCESS allows only single row inserts, most other RDBMS permit multi-row inserts. By default for RDBMS other than MSACCESS, the function prepares one SQL statement for 20 rows and ...

... I have also noticed that if I increase For nRow:=1 to 20 to let's say: For nRow:=1 to 30 :InsertAfter("Employees Status Report") Inserts the text at the last page... Is there a way to specify, on which page to include the text???? I'm sure all this questions will be addressed ...

... hago es crear un usuario exclusivo para el sistema FWH, que no sea conocido por ningun usuario. Asi garanto que solo el sistema pueda hacer los INSERTs, UPDATEs y DELETEs necesarios. Espero haber ayudado. saludos,

Hi All I am not sure who re openned this thread but I have been interfacing with the MYOB accounting package for ages now - using sql inserts - the MYOB datafile does not allow Updates or Deletes. function fnConnect(oCon,aPrivs)local cStr,oError,nAdoErrors := 0,oAdoErr,bDataFile := ...