SQL query not returning full properties

[vsantos01]

Hi all

I have created a support tool in C# which opens the EA file as a database and launches SQL queries to it. One of the things I'm doing is getting the URI property from Packages. Some of these URIs can be really long... so long that, although it is being stored in the EA file, the returned value from the SQL query is truncated. My parser of the obtained value fails because of unexpected format (missing closing delimiters and so).

Is there any known limitation on the amount of data returned from SQL query?

The field I am reading is Description from the t_xref table. Example of returned value: @PROP=@NAME=URI@ENDNAME;@TYPE=String@ENDTYPE;@VALU=uriofpackagea@ENDVALU;@PRMT=@ENDPRMT;@ENDPROP;

I am using eap files, meaning Microsoft.Jet.OLEDB.4.0 data provider.

Other queries work just fine.

Thanks,
Victor

[Geert Bellekens]

Yes, MS Access is limited to 256 characters (or something)

Switch to another database format.

Geert