Hello Divine, It is expected that you must understand the flow of the data schema of T24 as it relate to tables generally. As such try and follow Daniel Klein suggestion and make sure you understand the basic concept of how to write simple Jbase data extraction into flat file. Note it is not advisable to try and access STMT.ENTRY directly instead use concat table that links to that STMT.ENTRY table in your simple jbase script i.e. STMT.VAL.ENTRY
Good luck. rafael On 17 June 2014 11:18, Divine selasi <[email protected]> wrote: > Hello All, > > Thanks for your support. > > I tried the first option since i was not familiar with BASIC but i keep > getting errors. > Below is the error message please help me out. > Thanks for your support once again. > > *ERROR DESCRIPTION* > > jsh meta ~ -->SELECT FBNK.STMT.ENTRY SAVING EVAL > "STMT.ENTRY.ID:',:AMOUNT.LCY'" > SAVE.LIST TEST.CSV > !!! Error message Dictionary record SAVE.LIST is missing. > not found !!! > jsh meta ~ --> > > Regards, > Divine > > > > > On Tue, Jun 17, 2014 at 7:01 AM, Vladimir Kazimirchik <[email protected]> > wrote: > >> Hi, >> the quick-and-dirty way: >> >> (in jsh prompt; replace my_table to table name, FIELD1 etc to names of >> necessary fields) >> >> SELECT my_table SAVING EVAL "FIELD1:',':FIELD2:',':FIELD3" >> >SAVE.LIST out_file.csv >> >> to automate things you can create a paragraph. >> >> Cheers >> VK >> >> >> On Tuesday, June 17, 2014 1:23:18 AM UTC+5, Divine selasi wrote: >>> >>> Hello all, >>> >>> Please I want to export tables in my Jbase database to CSV on my >>> desktop. But i am having a challenge. >>> >>> Please anyone with any code that will help me achieve me aim. >>> Thanks for your help. >>> Best regards, >>> Divine >>> >> -- >> -- >> IMPORTANT: T24/Globus posts are no longer accepted on this forum. >> >> To post, send email to [email protected] >> To unsubscribe, send email to [email protected] >> For more options, visit this group at >> http://groups.google.com/group/jBASE?hl=en >> >> --- >> You received this message because you are subscribed to the Google Groups >> "jBASE" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> For more options, visit https://groups.google.com/d/optout. >> > > -- > -- > IMPORTANT: T24/Globus posts are no longer accepted on this forum. > > To post, send email to [email protected] > To unsubscribe, send email to [email protected] > For more options, visit this group at > http://groups.google.com/group/jBASE?hl=en > > --- > You received this message because you are subscribed to the Google Groups > "jBASE" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- * Ralph Olapade * -- -- IMPORTANT: T24/Globus posts are no longer accepted on this forum. To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en --- You received this message because you are subscribed to the Google Groups "jBASE" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
