Hi Patrick
try this code it works.....
static void exportToFile(Args _args)
{
Container con;
sqlDictionary sqlDictionary;
TableName TabName;
TextIO txtIo;
salestable salestable;
;
TabName = "SalesTable";
select * from sqlDictionary where TableName2id(TabName) ==
sqlDictionary.TabId;
if(sqlDictionary.RecId > 0)
{
txtIo = new TextIO('C:\\exportfile.txt', 'W');
txtIo.outFieldDelimiter("\t");
txtIo.outRecordDelimiter("\r\n");
while select salestable
{
txtIo.write(salestable.SalesId,salestable.SalesName);
}
}
}
hope this helps :)
Regards
Kamalakannan
http://casperkamal.spaces.live.com
On 7/4/07, chuapatrickd <[EMAIL PROTECTED]> wrote:
>
> Hi Cam,Robert and sreenath,
>
> I have created a text file and the result is shown below.
>
> "SO-00071" "ALDERITES MARKETING"
> "SO-00081" "ALDERITES MARKETING"
> "SO-00104" "ALDERITES MARKETING"
>
> It should look like this.
>
> SO-00071 ALDERITES MARKETING
> SO-00081 ALDERITES MARKETING
> SO-00104 ALDERITES MARKETING
>
> the codes now look like this.
>
> static void exportToFile(Args _args)
> {
> Container con;
> sqlDictionary sqlDictionary;
> TableName TabName;
> Comma7Io myfile;
> salestable salestable;
> ;
> TabName = "SalesTable";
> select * from sqlDictionary where TableName2id(TabName) ==
> sqlDictionary.TabId;
> if(sqlDictionary.RecId > 0)
> {
> myfile= new Comma7Io("c:\\exportedfile8.txt","w");
> myfile.outFieldDelimiter("\t");
> myfile.outRecordDelimiter("\r\n");
> while select salestable
> {
> //confiltered= [salestable.SalesId,salestable.SalesName];
> con= [salestable.SalesId,salestable.SalesName];
> myfile.writeExp(con);
> }
> }
> }
> How to revise to have tab delimiter record?
> Any help is greatly appreciated
>
> Thanks,
> Patrick
>
>
>
--
Regards
Kamalakannan
http://casperkamal.spaces.live.com
(Tech blog on Ax)
[Non-text portions of this message have been removed]
