V2.5 If you need help and cannot find it in the FAQ area of this forum feel free to ask the question and someone will reply back.
Moderators: webmaster, Christian, Kuok-Tim, ChrisClark, Forum Support
by ltjarl » Thu Apr 13, 2006 12:20 pm
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)
-
ltjarl
- Junior
-
- Posts: 3
- Joined: Wed Feb 09, 2005 5:51 pm
- Location: Sweden
by vetto » Thu Apr 13, 2006 2:45 pm
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
- Senior
-
- Posts: 70
- Joined: Sun Apr 09, 2006 9:19 pm
- Location: Connecticut - USA
-
by vetto » Sat Apr 22, 2006 12:51 am
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?
-
vetto
- Senior
-
- Posts: 70
- Joined: Sun Apr 09, 2006 9:19 pm
- Location: Connecticut - USA
-
by wnp » Sun Apr 23, 2006 9:11 am
Have you tried assembling this data in a variable and then using
the variable in the SQL statement?
-
wnp
- Junior
-
- Posts: 12
- Joined: Mon Nov 03, 2003 3:58 pm
by vetto » Sun Apr 23, 2006 7:19 pm
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?)
-
vetto
- Senior
-
- Posts: 70
- Joined: Sun Apr 09, 2006 9:19 pm
- Location: Connecticut - USA
-
Return to Zionworx V2.5 Support
Who is online
Users browsing this forum: No registered users and 3 guests