Search found 2954 matches: insert

Return to advanced search

Problema super raro (SOLUCIONADO)

... registros aunque adicioné mas de dos. He puesto un COMMIT y tampoco funciona Algun hilo?, ya copie código de otros PRGs, ya intenté con el comando INSERT y no hay éxito    oRsWrk:AddNew()   oRsWrk:Fields("WRK_FAC"):VALUE  := oWrk:FAC   oRsWrk:Fields("WRK_TXT"):VALUE ...
by Armando
Sat Mar 23, 2024 6:18 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Problema super raro (SOLUCIONADO)
Replies: 10
Views: 204

Re: Question about performance RowSet

... I am try this: aRow := oCn:QueryResult( "select field1,field2 from states where code='WA'" )if aRow == NIL // not found, then inserts    aRow := { "aa","bb" }    oCn:Upsert( "states", nil, { aRow } )endif  But insert ...
by Eroni
Wed Mar 20, 2024 7:01 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Question about performance RowSet
Replies: 19
Views: 466

Re: Question about performance RowSet

I am try this: Code: aRow := oCn:QueryResult( "select field1,field2 from states where code='WA'" ) if aRow == NIL // not found, then inserts aRow := { "aa","bb" } oCn:Upsert( "states", nil, { aRow } ) endif But insert not work. Table `states` has 3 fields: ...
by nageswaragunupudi
Wed Mar 20, 2024 3:19 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Question about performance RowSet
Replies: 19
Views: 466

Re: Question about performance RowSet

when i have a button to "insert' a new record, is there other way editing data without RowSet object? Please try this and let us know.   oData := TArrayData():New( oCn, "select * from <tablename> limit 1" ...
by Eroni
Wed Mar 20, 2024 1:50 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Question about performance RowSet
Replies: 19
Views: 466

Re: Question about performance RowSet

... "states", nil, { aRow } ) Mr Rao, this works when there exists any record from select. When the select there no result, insert does not work. I am try this: aRow := oCn:QueryResult( "select field1,field2 from states where code='WA'" )if aRow == NIL // ...
by Eroni
Wed Mar 20, 2024 1:46 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Question about performance RowSet
Replies: 19
Views: 466

Re: Compiling with new harbour_bcc770_32_20240309

... -v @yunus.bclTurbo Incremental Link 6.97 Copyright (c) 1997-2022 Embarcadero Technologies, Inc.Fatal: Unable to open file 'UUID.LIB' If I insert uuid.lib as mine project then it is compiled as you can see here https://i.postimg.cc/RCNsW7PZ/gg.png
by Silvio.Falconi
Wed Mar 20, 2024 9:13 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Compiling with new harbour_bcc770_32_20240309
Replies: 15
Views: 371

Re: Question about performance RowSet

when i have a button to "insert' a new record, is there other way editing data without RowSet object? Please try this and let us know.   oData := TArrayData():New( oCn, "select * from <tablename> limit 1" ...
by nageswaragunupudi
Sat Mar 16, 2024 1:18 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Question about performance RowSet
Replies: 19
Views: 466

Question about performance RowSet

... when I need to obtain data from several tables for editing in multiple browsers becomes very large. For example, when i have a button to "insert' a new record, is there other way editing data without RowSet object? Thanks in advance.
by Eroni
Thu Mar 14, 2024 8:02 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Question about performance RowSet
Replies: 19
Views: 466

Re: ButtonBmp problem with FWH2402

...     = lGDIPreturn ::Super:Redefine( nId, bAction, oWnd, nHelpId, cMsg, lUpdate, bWhen,;                       bValid, cPrompt, lCancel )  Insert this line ::lUnicode  = oWnd:lUnicode as indicted below: METHOD ReDefine( nId, bAction, oWnd, nHelpId, cMsg,;                 lUpdate, bWhen, ...
by richard-service
Thu Mar 07, 2024 8:36 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: ButtonBmp problem with FWH2402
Replies: 25
Views: 700

Re: ButtonBmp problem with FWH2402

...     = lGDIPreturn ::Super:Redefine( nId, bAction, oWnd, nHelpId, cMsg, lUpdate, bWhen,;                       bValid, cPrompt, lCancel )  Insert this line ::lUnicode  = oWnd:lUnicode as indicted below: METHOD ReDefine( nId, bAction, oWnd, nHelpId, cMsg,;                 lUpdate, bWhen, ...
by nageswaragunupudi
Thu Mar 07, 2024 8:18 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: ButtonBmp problem with FWH2402
Replies: 25
Views: 700

Re: To Nageswrao Del Objs on TscrollPanel

... two buttons I cannot delete printer button https://i.postimg.cc/NFWzkLT2/2.png then I have another situation the final user can insert items directly on tpanel, only on another dialog can delete the btnbmp these items are quick links to recall some application procedures, so ...
by Silvio.Falconi
Mon Mar 04, 2024 9:13 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: To Nageswrao Del Objs on TscrollPanel
Replies: 17
Views: 498

Re: Por qué el error en este SELECT?

Amigos: Les comparto mi experiencia en este tema: 1.- Creo una tabla con la estructura descrita en este hilo 2.- Con NaviCat hago un INSERT con SELECT desde una tabla de una versión anterior de mi aplicación. 3.- Al crear el xBrowse lo crea bien pero al pedir mostrar registros de un año ...
by Armando
Mon Mar 04, 2024 3:50 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: Por qué el error en este SELECT?
Replies: 9
Views: 203

Re: xBrowse with UrlLink

... everyone has the right and freedom of expression, but dear sir it seems strange to me that you too, like someone else in this forum, when I insert a specific topic, immediately a topic with the same subject is inserted or something similar related to my previous topic. I repeat, everyone ...
by Silvio.Falconi
Wed Feb 28, 2024 9:00 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: xBrowse with UrlLink
Replies: 3
Views: 142

Re: Add a new taskPanel on Explorerbar ( on line)

I think we would need a new method directly in the texplorerbar class to insert taskpanel in x position
I sent to Linares my Idea for two new methods
by Silvio.Falconi
Tue Feb 27, 2024 11:46 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Add a new taskPanel on Explorerbar ( on line)
Replies: 2
Views: 148

Add a new taskPanel on Explorerbar ( on line)

At init I have https://i.postimg.cc/jddnRVhH/second.png and I wish insert a taskpanel after the first taskpanel on line ( I wish the final user can add the second Panel on line) https://i.postimg.cc/fTDWNxD1/second.jpg I not Found ...
by Silvio.Falconi
Sun Feb 25, 2024 5:06 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Add a new taskPanel on Explorerbar ( on line)
Replies: 2
Views: 148
Next

Return to advanced search