reg. faq149-3226 1

[adhhealth]

Ido Millet,
THis Faq you have submitted is useful. But in my case I donot have rights to create another table in the same data dictionary as the other tables.(So I cannot create another table by name "Repeater" in the same database)

Crystal version 8,database pervasive sql version 6.

problem: If I create a table in another database I CANNOT "Edit SQL query" (because I am using multiple datasources). I need to edit the sql query because the {Order.quantity} field is "String" datatype and I need to Convert({Order.quantity},sql_integer) to compare it with Repeater table.Can you suggest something here??
Thanks.

 

[synapsevampire]

If you're able to create tables in another dictionary, perhaps you can create views that point at the tables in another dictionary. So just create views for those other tables and based the query within the dictionary where you can create tables/veiws.

-k

 

[adhhealth]

THANKS A LOT..Its a relief!!!!!!!!!It works...