good time to switch to a DBMS. the best choice is to use a commercial database because your support is not limited, for example you can use Oracle, MySql, MS-SQLServer or others. my advice, stop using the free version of the database. ...
... we still may have to adopt some kind of conditional coding for assignment of Dates if we want our code to be generic ( not targeted to single DBMS only) Example: oRs:Fields( "SomeDate" ):Value := STOD( "17000101" ) This works for Oracle, MYSql and all non-Microsoft products. ...
... mention about the limitation of excel about the lowest being 1900-01-01. This is the limitation of other Microsoft SQL databases also. Other SQL DBMS like Oracle, MySql all accept all dates. Our request is not purely Excel centric as they are discussing. Issue of dates lower than 1900-01-01 has ...
... Which one is better? If you use DBFCDX, you can store and retrieve RTF data in the Memo fields like any other text/binary data. If you use any DBMS I recommend using BLOB fields or the requried size. Using ADO reading and writing binary data is very simple. In particular, TXBrowse, TRecSet. ...
FWH Ado functions work for Access, MS Sql, MySql, Oracle and SQLite3. That means "all" functions in adofuncs.prg work for these DBMSs. Just a clarification. Many functions work for *all* DBMSs. For example, for creation of Table on DBMS, we need to know specific datatypes of the ...
Mr. Rao, I am getting the following error when trying to display 'DBMS Name' Application =========== Path and name: C:\Winapps\cargo\data\cdmsql.exe (32 bits) Size: 2,547,200 bytes Compiler version: xHarbour 1.2.3 Intl. (SimpLex) (Build 20130422) FiveWin ...
... script. The function is return the following SQL script. However, the syntax is not correct for MS SQL, `ID` should be [ID]. I see a function (FW_RDBMSName)is called to determine DBMS type but it does not seem to be working. Can you tell me what I am doing wrong? CREATE TABLE `air` ( `ID` INT AUTO_INCREMENT ...
... : http://harbourlanguage.blogspot.com/2010/04/harbour-netio.html 3.- Advantage Database Server And if you don't need to keep DBF you can find many DBMS and connect to them directly or by ODBC or OLEDB Saludos Marcelo
George, of course, you can use ADS like other DBMS like MS SQL or MySQL. You can use SQL with your DBF now without change your code, you don´t need a ADS remote server, SQL work with local server too, the difference with remote server is the transactions, ...