Search found 102 matches: inserts

Return to advanced search

FWH: MySql/MariaDB: RowSet object

... are automatically seen in all the Clones. The internal linkage of the Clones does not work / broken in the following cases. a) Deletions and Inserts are not seen by other clones. (differs from ADO) b) ReQuery() of a Clone totally de-links it from other clones. (like ADO)
by nageswaragunupudi
Thu Jul 21, 2016 11:50 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: FWH: MySql/MariaDB: RowSet object
Replies: 51
Views: 19754

FWH 16.08 : Built-in MySql/MariaDB functionality (Updated )

... METHOD SetMultiStatement( lOnOf ) METHOD max_allowed_packet_MB( nNewVal ) METHOD GetAutoCommit() METHOD SetAutoCommit( lOnOff) Note: Multiple row inserts are speeded up autocommit is disabled before insert and enabled after insert. METHOD Ping() --> lSuccess METHOD BeginTransaction() METHOD ...
by nageswaragunupudi
Fri Jul 01, 2016 9:32 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: FWH 16.08 : Built-in MySql/MariaDB functionality (Updated )
Replies: 76
Views: 28596

Problem with Preview from trichedit RESOLVED

... ) ; ACTION ( ::WndChild():Copy(), ::WndChild():SetFocus() ) DEFINE BUTTON RESOURCE "RTFPaste" OF ::oBar1 ; MESSAGE "Inserts Clipboard contents" ; TOOLTIP "Paste" NOBORDER ; WHEN ( ::WndActive() .and. ::WndChild:CanPaste() ) ; ACTION ( ::WndChild():Paste(), ...
by Silvio.Falconi
Tue Apr 26, 2016 11:37 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Problem with Preview from trichedit RESOLVED
Replies: 4
Views: 1057

SQL INSERT TRIGGER Failure in Xharbour

Hi All, I have a new trigger in SQL which inserts a new record in another table, but I am getting a blowup Error description: Error BASE/1132 Bound error: array access Args: [ 1] = A { ... } [ 2] = N 1 Stack Calls =========== Called from: ..\source\sqlrdd2.prg ...
by paulrogers
Thu Jan 21, 2016 3:37 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: SQL INSERT TRIGGER Failure in Xharbour
Replies: 0
Views: 342

New FTDN November/Noviembre 2015 (FWH 15.11)

... Enhancement: SQL INSERT command. Now column names are optional. New: SQL INSERT INTO <table> [( <colnames> )] ARRAY aData for Bulk Inserts * Enhancement: Cuebanners of TGet and TEdit now support Unicode also. * New functions: StrToWide() and WideToStr(). Appropriately use Ansi/Unicode ...
by Antonio Linares
Sat Dec 26, 2015 9:26 am
 
Forum: WhatsNew / Novedades
Topic: New FTDN November/Noviembre 2015 (FWH 15.11)
Replies: 5
Views: 2806

New FTDN October/Octubre 2015 (FWH 15.10)

... Enhancement: SQL INSERT command. Now column names are optional. New: SQL INSERT INTO <table> [( <colnames> )] ARRAY aData for Bulk Inserts * Enhancement: Cuebanners of TGet and TEdit now support Unicode also. * New functions: StrToWide() and WideToStr(). Appropriately use Ansi/Unicode ...
by Antonio Linares
Sat Dec 05, 2015 11:27 am
 
Forum: WhatsNew / Novedades
Topic: New FTDN October/Octubre 2015 (FWH 15.10)
Replies: 0
Views: 929

New FTDN August/Agosto 2015 (FWH 15.08)

... * Enhancement: adofuncs.prg - function FWAdoCreateTable( cTable, aCols, oCn, [ lAddAutoInc := .t. ] ) Existing behavior: By default, the function inserts an autoincrement primary key column with the name "ID", if the aCols[ 1 ] is already not of type "+" This behavior can be ...
by Antonio Linares
Wed Sep 09, 2015 9:12 am
 
Forum: WhatsNew / Novedades
Topic: New FTDN August/Agosto 2015 (FWH 15.08)
Replies: 12
Views: 3582

Re: ADO SQL VISIBILITY

... select max otherwise we could have Lastrec() returning 20 and recno 35! Next question is how frequently we need to keep checking for other users' inserts. We can't keep checking continuously. If the reocrdset is ordered on the primary key, it may be enough to check when (i) DBGOBOTTOM() and (ii) ...
by AHF
Tue Jun 30, 2015 7:41 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADO SQL VISIBILITY
Replies: 17
Views: 3482

Re: ADO SQL VISIBILITY

... such cases comparing the max() values indicates activity by other users. Next question is how frequently we need to keep checking for other users' inserts. We can't keep checking continuously. If the reocrdset is ordered on the primary key, it may be enough to check when (i) DBGOBOTTOM() and (ii) ...
by nageswaragunupudi
Tue Jun 30, 2015 1:40 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADO SQL VISIBILITY
Replies: 17
Views: 3482

Re: ADO RDD xHarbour

... not fail. Table is the same ? Here that version its working. There must be something wrong with your config. Here all its working. ADO_OPEN it inserts field set to be used as recno as first field primary key. Do you have SET ADO DEFAULT RECNO FIELD TO .. defined?
by AHF
Sat May 23, 2015 10:25 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADO RDD xHarbour
Replies: 1047
Views: 447173

Re: Grabar en tablas relacionadas en Mysql

... topics. FWAdoCreateTable( "test", { { "PROG", "N", 5, 0 }, { "NAME", "C", 30, 0 } }, oCn ) inserts one auto-increment column ID as the first column and as primary key. The resultant table will have 3 columns ID,PROG,NAME with ID as auto-increment ...
by nageswaragunupudi
Tue Mar 17, 2015 2:15 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Grabar en tablas relacionadas en Mysql
Replies: 10
Views: 2174

Re: FWH and Word - OLE

Enrico,

I think you misunderstood my question.

In my application, I open a RTF-file in Word, using OLE. Then I want my application to save it as a Word 1997-2003 document.

The solution you suggested (I think) inserts a rtf-file into a Word-document, doesn't it?

Thanks.
by driessen
Tue Feb 03, 2015 9:54 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: FWH and Word - OLE
Replies: 9
Views: 1796

Re: En tiempo de compilacion...

... to accept whole rule even if it was possible to find a valid match in differ way. 16. Result markers. <idMarker> Regular result marker - inserts matched result as is without any modifications. The first token inherits number of leading spaces from the result pattern. #<idMarker> ...
by Antonio Linares
Tue Aug 26, 2014 7:44 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: En tiempo de compilacion...
Replies: 3
Views: 1565

Re: ADO & SQL INSERT Statement

... after which the transaction terminates. Re-examine the INSERT statement on page ***. The statement by itself, not part of a cursor definition, inserts a single row into the customer table. In fact, the whole apparatus of the insert cursor can be dropped from the example code, and the INSERT ...
by avista
Thu Jul 31, 2014 7:28 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADO & SQL INSERT Statement
Replies: 9
Views: 2220

Re: ADO & SQL INSERT Statement

... 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 ...
by avista
Thu Jul 31, 2014 6:59 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADO & SQL INSERT Statement
Replies: 9
Views: 2220
PreviousNext

Return to advanced search