FiveTech Software tech support forums

...     BITMAP .\..\bitmaps\32x32\exit.bmp*/// FIN / END  Regards, saludos. certainly darling, but I wanted it automatically, I didn't want to insert the width and height of each button, if in a window I have 80 buttons all with different sizes, how many lines of source do you think I should ...

Thank you, for your amazing support!

Please connect to this server

Code: Select all  Expand view

maria_Connect( "209.250.245.152,fwh,fwhuser,FiveTech@2022" )

and upload your tables there.

Good Morning Mr Rao, I made a test with oCN:InsertSQ() and it's also returning a wrong sentence. It's returning this: INSERT INTO `folha` ( `cemp`,`nfolha`,`cmat`,`cvandes`,`cvdorig`,`val_inf`, `val_calc` ,`total_inc`,`filial`,`clotacao`,`prazo`,`situacao` ) VALUES ( '047','9WZ','00261','500','500',0, ...

Karinha,
For me it's no good
I have a dialog with many get , how row of source I must make for insert your source ?

look the sample's Nages , why here not run ?

I sent through google chat a complete little sample to you. Please, try it.

When you face such problems, I suggest you compare the
oCn:InsertSQL( ... )
with
oCn:CreateTableSQL( <table> )

or
Please create a small sample that we can execute at our end on the above cloud server.

I did this small test function mariaInsert()   local oCn := maria_Connect( "209.250.245.152,fwh,fwhuser,FiveTech@2022" )   ? "start"   oCn:DropTable( "testinsert" ...

Dear Friends, I'm having a huge problem with Insert/MySql. I have a Decimal field where I'm tryng to save the value 1(one), but it's saved as 0(zero). Bellow i'm showing a little sample where the problem is happening. function Main()LOCAL ...

... 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 ...

... 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 ...

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: ...

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" ...

... "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 // ...

... -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