Hi All,

I'm using R09 and MS SQL Server 2008. I have difficulty to show all the table structure. I've check the database and it's only show 2 fields: XML ID. Is there anyone can help me to solve the issue?

Thanks,
Mulyono

Hello Mulyono,

This is how T24 works with SQL server and Oracle.
Since jBASE is NOT a relational data-base (RDBMS) when working with SQL Server & Oracle there is a driver that converts the jBASE format to XML and back.

When T24 writes a record the driver translates the jBASE format to one long XML string and stores it in the SQL/Oracle data-base
When T24 reads a record the driver goes and read the XML string and translates it back to jBASE format.

Hi Lior,

Is there any simple way to check the table structure (eq: AC module) from database without going through jBASE like RDBMS? I can view the table structure using command in jBASE but have to redo for each module.

Thanks

I'm not sure I fully understand your question.

When you say table structure, do you mean list of fields?
If so, you will need to look at the STANDARD.SELECTION application via T24 and you will need to do it one table at a time.

Yes, that is what I mean. Is there any way than STANDARD.SELECTION to view all the fields of tables?

thanks,

Again, I don't understand what you mean.

In STANDARD.SELECTION you will see ALL the fields for each table.

If you want to see all fields of all tables you will need to check ONE table at a time.
Alliteratively, you can write a program in jBASE that will read the STANDARD.SELECTION and make some kind of output.

For SQL Server/Oracle there are always only 2 fields per table: ID + XML

You can also refer DICT file which holds the field name & field format & fiedl number for all T24 files.