Search found 67 matches: dbms

Return to advanced search

Re: ERRORES EN EL VOLCADO DE DATOS EN UNA RED LOCAL

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. ...
by Mulyadi
Thu Jan 27, 2022 1:28 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: ERRORES EN EL VOLCADO DE DATOS EN UNA RED LOCAL
Replies: 13
Views: 765

Re: bug TDataRow

Thank you.

What about backing up and restoring tables to an external txt file via ADO, irrespective of DBMS? The lib does provide this feature now?
All the best,
by MOISES
Fri Sep 20, 2019 4:49 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: bug TDataRow
Replies: 11
Views: 1022

ADO back up full database

Hi,

Using ado/FW_ado functions as DBMS management irrespective of MYSQL, MSSQL, etc, is there a way to back up the whole database to a local file?

Thank you
by MOISES
Fri Sep 13, 2019 2:44 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADO back up full database
Replies: 6
Views: 1256

Firebird funciones

... (), FBClose (), FBStartTransaction (), FBRollback (), FBQuery (), FBCommit (trans), FBGetData (), FBFree (), FBClose (DB ) - para acceder al DBMS Firebird. ¿Alguien puede ayudarme? Gracias! Rodrigo Melo Belo Horizonte / MG Brasil
by ip_ram
Wed Mar 18, 2015 6:45 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Firebird funciones
Replies: 2
Views: 507

Firebird functions

... (), FBClose (), FBStartTransaction (), FBRollback (), FBQuery (), FBCommit (trans), FBGetData (), FBFree (), FBClose (DB ) - to access the DBMS Firebird. Can anyone help me? Tks! Rodrigo Melo Belo Horizonte / MG Brazil
by ip_ram
Wed Mar 18, 2015 6:44 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Firebird functions
Replies: 1
Views: 408

Alguien utiliza Firebird?

Hola!

Alguien utiliza Firebird como DBMS?

Pregunte por ser el Firebird a menos exigentes recursos del sistema que MySQL, MariaDB, OracleExpress y otra ...

¿Cuál es su opinión?

Gracias

Rodrigo Melo
Brasil
by ip_ram
Mon Mar 09, 2015 8:04 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Alguien utiliza Firebird?
Replies: 4
Views: 517

Re: Migrating to Harbour

... 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. ...
by nageswaragunupudi
Sat Jan 10, 2015 1:02 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Migrating to Harbour
Replies: 238
Views: 44516

Re: Migrating to Harbour

... 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 ...
by nageswaragunupudi
Sat Jan 10, 2015 12:50 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Migrating to Harbour
Replies: 238
Views: 44516

Re: Need expert comment

... 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. ...
by nageswaragunupudi
Thu Oct 09, 2014 3:08 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Need expert comment
Replies: 3
Views: 804

Re: ADO RecordSet to DBF

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 ...
by nageswaragunupudi
Mon Jul 14, 2014 1:59 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADO RecordSet to DBF
Replies: 16
Views: 4761

Re: DBF to SQL script tool

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 ...
by cdmmaui
Fri Jun 27, 2014 11:25 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: DBF to SQL script tool
Replies: 50
Views: 13500

Re: DBF to SQL script tool

... 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 ...
by cdmmaui
Fri Jun 27, 2014 4:00 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: DBF to SQL script tool
Replies: 50
Views: 13500

Re: se puede en un SELECT insertar un IF?

Hola,

dependiendo el DBMS puedes hacer algo asi

SELECT *
FROM tabla
WHERE substr( campo2, 2, 1 ) = '1'

revisa la función equivalente a substr del DBMS que estés utilizando, en MySQL SUBSTRING(str,pos,len) pero creo que SUBSTR es un sinónimo

saludos

Marcelo
by Marcelo Via Giglio
Wed May 28, 2014 12:29 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: se puede en un SELECT insertar un IF?
Replies: 6
Views: 674

Re: How To Connect DBF file Via IPaddress

... : 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
by Marcelo Via Giglio
Fri May 16, 2014 11:33 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: How To Connect DBF file Via IPaddress
Replies: 2
Views: 539

Re: FiveWeb (FiveWin days are numbered)

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, ...
by Marcelo Via Giglio
Tue Apr 08, 2014 1:56 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: FiveWeb (FiveWin days are numbered)
Replies: 70
Views: 24812
Next

Return to advanced search