FiveTech Software tech support forums

Hello, I convert csv files to dbf files by code. I have the fieldnames in a array adata from a other piece of code, and want to make a dbf out of it. The problem is that the fieldnames in csv are often longer than 10 characters. adata contains example : ID Name Price information1 information2 inform...

... a table with lot of records. The problem is that running the query to get the recordset is taking already 3 .5 seconds. What I can do is setting a LIMIT op 1000 records, and fetching the next 1000 when I get to the buttom of the browse. HeidiSQL is doing this by doing SELECT  * FROM .. ORDER BY ...

... -I%C_INC_INSTALL%\dinkumware64%CRLF% -I%C_INC_INSTALL%\windows\crtl%CRLF% -I%C_INC_INSTALL%\windows\sdk%CRLF% -O2%CRLF% -ferror-limit 50 -fmessage-length 126 -fno-use-cxa-atexit%CRLF% -fborland-extensions -std=c++11 -fcxx-exceptions -fexceptions -fseh %CRLF% -fdiagnostics-show-option%CRLF% ...

... -I%C_INC_INSTALL%\windows\crtl -I%C_INC_INSTALL%\dinkumware64 -I%C_INC_INSTALL%\windows\crtl -I%C_INC_INSTALL%\windows\sdk -O2 -ferror-limit 50 -fmessage-length 126 -fno-use-cxa-atexit -fborland-extensions -std=c++11 -fcxx-exceptions -fexceptions -fseh -fdiagnostics-show-option -fcolor-diagnostics ...

... works only for either (a) simple table name or (b) if the sql statements ends with "ORDER BY <x>". This method internally uses LIMIT/OFFSET clauses to retrieve the first NumRows records. Later we can use oRs:ReadNext( n ) --> lMoreRecsRemaining to read next n records or oRs:ReadNext() ...

... una sola fila. function MayorSueldo( nro_legajo int ) returns decimal( 12, 2 ) Begin select teorico from sac001 where id_legajo = nro_legajo limit 1; End

... controls TGet and TEdit for imput of single line text. While these controls can be used to imput any other type of variable, present discussion is limited to text input only. In the case of Unicode applications, i.e., applications built with FW_SetUnicode( .t. ), these controls accept Unicode character ...

... changes were saved. * Enhancement: TXBrowse method ToExcel() now exports images also. * Enhancement: TEdit control: Addtional clauses (1) [ <limittext: LIMITTEXT> [ BY <nchars> CHARS ] ] By default, Edit control does not limit the characters entered like' TGet. When LIMITTEXT clause ...

... How can show UTF8 database in FWH? .or. What I do wrong? http://s33.postimg.org/ua1lx04vz/My_Sql_UTF8.jpg image upload no size limit

... I open xBrowse . example: SELECT * from mydatabase I know that the delay is in the select and not xBrowse . If I use : SELECT * from mydatabase LIMIT 100 and I open xbrowse , I have no delay . When I browse the data and arrive at the record 100 the command skip() should make another select SELECT ...

... my old request , I think it is connected to this topic. I saw that browse for SQL ( like Mysql-Front) use this process SELECT * FROM dabase.client LIMIT 100 when I go over the 100 records automatically there is another select SELECT * FROM dabase.client ORDER LIMIT 100,100; it would be nice to ...

1)Is there a limit of rows for a recordset using this functions or a limit to export to dbf files, because I tried to export 700.000 records from a mysql table to a dbf file .and. it returns this error There is no such limit in ...

... is interesting the study of FWH ADO functions, I start to study them because of this post, and I'd like to make you some questions. 1)Is there a limit of rows for a recordset using this functions or a limit to export to dbf files, because I tried to export 700.000 records from a mysql table to ...

... I have found to work well over the next few days, and ask that anyone else using the IDE feel free to include their observations as well. PLEASE LIMIT THIS THREAD TO THE IDE. I know there are alternative methods of assembly, but those are all discussed in other threads. I know some will ask "Why ...

Mr. Rao, my impression is, that this point are not done!?

2. To limit the listbox on small browses.
nWidth := min(nWidth,::oBrw:BrwWidth()) //BYTE-ONE