pio Posted February 23, 2011 Share Posted February 23, 2011 Hello, I need to read an array of String (about 10 elements) and display (no modify) all of them on pages. But I got 2 problems: 1. DAQ convert my String to number (I've used db.Query() and db.QueryToClass(), still same) 2. I can't display my text on page Can you help me solve this problem? Link to comment Share on other sites More sharing options...
AzeoTech Posted February 23, 2011 Share Posted February 23, 2011 1. This is probably because the fields are Text, not VarChar. DAQFactory doesn't support Blob data types, and thinks they are numbers. You need to used a fixed width string data type in your table 2. Just use global string variables to store the results of your query and use variable value controls to display those string variables. Link to comment Share on other sites More sharing options...
pio Posted February 24, 2011 Author Share Posted February 24, 2011 Great, my problem solved. I used "nvarchar" data-type. Now DF display my text correctly. Cheers, B) Link to comment Share on other sites More sharing options...
AzeoTech Posted February 24, 2011 Share Posted February 24, 2011 Good. Sorry I didn't know the type for your database. While SQL is somewhat standard, there are many different dialects, so to speak, and it seems every database uses a slightly different naming convention for their data types. A "blob" data field is one with unlimited length, usually not indexable, and often stored outside the core binary database structure. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.