exportText() problem

[Vansh Singh]

Ruslan,

Yes, the problem was with the database and not really a problem with
exportText() function call. 

I am using one database to update another database by exporting and
importing the data in text files (that's why there is a loop that goes
over all the relevant tables). This import/export requires both the
databases to have the same exact schema (at least for the relevant
tables), and if there is a difference of even 1 column missing between
the 2 sets of tables, the export process fails. The only thing nice
would be if it generated a 'warnings' file saying something about the
schema mismatch.

I have now fixed the schema and it works fine. Thank you for all your
help.

Regards,
Vansh

-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] On Behalf Of Ruslan
Zasukhin
Sent: Friday, December 12, 2008 4:07 AM
To: valentina at lists.macserve.net
Subject: Re: exportText() problem

On 12/12/08 2:27 AM, "Vansh Singh" <vsingh at us.counterp.com> wrote:

Hi,

> Hello,
> 
> I have an issue where the call to exportText() doesn't work. The code
> that calls exportText is in a loop and it does generate a few text
files
> but always chokes right after creating the same text file every time I
> run a test. I am looking at the documentation and it says that
> exportText function returns a void so there is no return variable to
> look at. 
> 
> Here is the code I have:
> 
>       if export_cursor.recordcount > 0 then
>         fileToExport=target_db_path&table_list[i]&".txt"
>         Alert("fileToExport is:"&fileToExport)
>         export_cursor.exportText( fileToExport, TAB, RETURN )
>       end if
> 
> Any help will be much appreciated.

Please try to diagnose your database.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]


_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina