FiveTech Software tech support forums

... SQLWIN is a translator, that takes the DBFs syntax and convert it into SQL sentences. Basically you connect to a DataBase engine and start issuing SQL sentences. The advantage over ADO (we also created ADORDD) is that ADO is ...

... mode. with ads you can migrate your files now, without change of code, and with time, add more ads features like transaction, data dictionary, sql sentences, remote filters, etc... but ADS is a SAP / Sybase company today, and this is not free... have a version free to 2 workstations and server, ...

Enrico,

First you have to run wsserver.exe and keep it opened, then open the HTML page.

From the command line you can write sentences like: ? Time(), ? hb_version(), etc

it uses Harbour's macros. Possibilities are endless

...   ADSCreateSQLStatement( cAlias, 3, hads )            ADSPREPARESQL( consulta )            ADSEXECUTESQL()  to execute SQL sentences, the result is correct but I get this error notification, some idea? I am using ADS 7.1, last official xHarbour compiled to work with ADS ...

... .. a class to manage these database directly .. I migrated one of my programs to MySQL using fwh with ADO and it works fine. I use the same SQL sentences that I use in another part I migrated to PHP. What is the advantange of managing the database directly instead of ADO ? Speed? Thank you in ...

... .. a class to manage these database directly .. I migrated one of my programs to MySQL using fwh with ADO and it works fine. I use the same SQL sentences that I use in another part I migrated to PHP. What is the advantange of managing the database directly instead of ADO ? Speed? Thank you in ...

All these ideas are very good. I write regularly, just short notes, maybe 2 or 3 sentences stating some change or bug fix. I do it to a news.txt file using html notation. The file is accessed by the webpage when the user clicks on what's new menu option. Any time ...

... my solution was too simple, too quick, and she needed to speak more. I honestly believe that to state a problem shouldn’t take more than three sentences. As a rule of thumb, if a user takes more than 1 minute to explain a problem, then they are confusing a problem with a solution. Today I tried ...

... screens, and in Mac you can use "Interface Builder" to design them too, but finally you have to copy the coordinates to @ ..., ... xbase sentences. In Linux we can use the Glade file format screens, as they are, but they don't behave exactly as Windows RC files.

Hello, thanks for response, I don't have problems with SQL sentences (sintax ,etc), e.g. if you try to delete some record DELETE FROM table WHERE column=data if some row on the table are locking for other user you have an error from ADS not from xHabour, ...

Thanks to Felix we have used mysqlcheck to auto repair the tables, instead of using SQL sentences.

Hopefully this may help.

... governed by the database engine ?? > Its easy :-) The idea is to store the indexes tags and expresions in the server, so when we issue some SQL sentences that require indexes then we use: ... ORDER BY <index_expression_stored_in_server>, sql_recno i.e.: SELECT ALL FROM `test_dbf` ORDER ...

... many questions, it would just understand that their goals. At this stage we are just translating the Db...() functions into their equivalents SQL sentences. Okay, I understand this. Another issue is: the result set will be maintained in its original format and converted via C (as DBFCDX / NTX, ...

Vailton, At this stage we are just translating the Db...() functions into their equivalents SQL sentences. Next step is to make a real connection and it will be done using language C (C wrappers), to turn it real fast. Some connections may require ODBC, others will use ...

Rafa,

This RDD does not use ADO at all. It just still has old code from ADORDD that has to be deleted.

The SQLWIN RDD just issues SQL sentences: It translates Db...() functions to SQL code, so we can use it with any database engine that supports SQL.