tdbDataX syntax

[ltjarl]

Hi,

Anyone get tdbDataX export to work?

Try and the export start but never finish...

Anyone now the syntax or have any idé?

(have try tdbDataX c:\temp\data\MainTable.dat text.txt)

[vetto]

tdbDataX.exe MainTable.dat exported.xml -fmybase

Not sure what you are trying to get out of this export...other that to see what the DB contains...

Try these tools instead:
roTDBtools from http://rwblinn.wikihost.org/programm/gebo.prg?name=rotdbtools

The roTDBsql tool is great and easy to figure out.

[vetto]

I am trying to insert the lyrics into the "widememo" field...but cannot get the carriage return between lines to go in.

The SQL is:

Code: Select all


insert into "maintable.dat" (title1,lyrics,writer,copyright) values ("test title 5","Lyric line 1" + CHR(13) + "and then line 2" + CHR(13) + "and then another line 3","matt stewart","1999 Makebelieve music")


The record is created but the lyric field is blank...removing the chr(13) and surrounding concats works as it should...one long string with no line breaks

How do I insert a carriage return/line feed in the lyrics?

Any SQL guys out there?

[wnp]

Have you tried assembling this data in a variable and then using
the variable in the SQL statement?

[vetto]

That was my first thought...but the query analizer wont do it, and I dont know the connection string for TurboDB to do it via PHP. (Do you?)