FiveTech Software tech support forums

for the 4th column I have problem because I cannot insert more characters Add this code: oBrw:aCols[ 4 ]:nDataLen := n  // where n is the number of chars you want to enter OR oBrw:aCols[ 4 ]:lVarChar := .T.// AND/ORaCols[ 4 ]:nMaxLen ...

for the 4th column I have problem because I cannot insert more characters

Add this code:

Code: Select all  Expand view

oBrw:aCols[ 4 ]:nDataLen := n  // where n is the number of chars you want to enter

OR

Code: Select all  Expand view

oBrw:aCols[ 4 ]:lVarChar := .T.
// AND/OR
aCols[ 4 ]:nMaxLen := n

... this xbrowse with an array https://i.postimg.cc/Mp3kGctt/gor.png when I modify 4th column and the string is "45" i can insert only 2 space how I can resolve ? I made WITH OBJECT oBrwFilter      :bPastEof     := { ||  AddRow( oBrwFilter ) }      :bKeyDown ...

... by" 1) married 2) unmarried 2) if I click in the second checkbox (age) the procedure must further change the dimensions of the xbrowse and insert the three possibilities with radioitems above 1) 20 2) 40 3) over 50 https://i.postimg.cc/zB7jyJ2Z/kk.png #include 'fivewin.ch'#include ...

... for example I would like to know the married and the unmarried when I click on the first checkbox the procedure must raise the xbrowse and insert two married / not moved radio controls if I click on the second checkbox it must raise the xbrowse and insert 3 checkboxes 50 years, 25 years, ...

... #command dbcommit <(AREA)> => dbcommit_SQL( <(AREA)> ) function dbcommit_SQL(area) // obtener el replace x dbf // hacer el update (insert) sql return nil Gracias JONSSON RUSSI

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