Search results

Thanks for the response, Casper. The database I'm working with has stupid way of handling large amounts of text. In their UI they have a Comments field where the user can enter as much text as they'd like but the data is stored in another table as multiple records with only 50 characters in...

Thanks for the responses guys. The INSERT...SELECT syntax only works if you have data in an existing table. If the user is entering new data in my app, specifically line items of an order, then the data doesn't exist in another table yet. The line item records are of all of the same type of...

Can anyone tell me how to perform the equivalent of a Group Concat function in Progress SQL? I want to get a concatenation of multiple records into a single record. For example, this SQL produces a set of data SELECT data1 FROM table1 WHERE data2=True +-------+ | data1 | +-------+ | somet | |...

erased !

Okay, the more digging I do the more frustrated I get. I think I found out that I'm not using ESQL and I am using SQL-92. But I have yet to be able to find a way to insert multiple rows in a single insert statement. Does anyone have anything that can help me?

Yes, I'm using the db navigator in OE architect. Please excuse me ignorance but I don't understand what your response has to do with my question.

Thanks for the reply Tom, I using SQL but I don't understand what you mean by "make sure that you are using SQL-92 and not the embedded SQL-89 syntax". How do I specify which syntax to use? I'm writing a VB app that connects to an existing Progress system. I use OpenEdge Architect to test my...

I can't believe this hasn't been asked before but I've searched and haven't found anything on this topic. I'm just starting with OpenEdge 10.0B03 and I'd like to insert multiple records with a single insert statement like I do in MySQL In MySQL I can do the following, Insert Into Tablename...