Recent content by Shubhrant

Hi All, need your help on a requirement. it goes like: i have a delimited file with unknown numbers of columns. i can able to create a dynamic temp-table and populate entire data properly in that temp-table. Now i want to copy all these records to a static temp-table which is nothing but a...

I need one support on reading field values in a frame while entering to the first field of the frame. according to the below example: Once I enter to the screen, the field value of the marked should be "YES". By default this field value remains as "NO". I have to make changes through triggers...

Cringer... Appreciate you support. Code has worked and running smooth now.

{mfdtitle.i} define variable qh as widget-handle. define variable buf as widget-handle extent 10. define variable numvar as integer initial 10. define variable cQuery as character no-undo. define variable mTable as character no-undo format "x(20)". define variable cTable as character...

Hey Cringer....you are a Star. Finally i managed to get the output as expected with the FIRST-OF(). Just a quick suggestion on the error ...actually a progress error for This is not a show stopper. actually for the last record with blank value this appears. Even though i tried to suppress it...

My progress version is 10.1 CHUI with MFG/Pro eb2 SP1. I have attached the code in the previous communication... in that code while creating the QUERY i have added a break by. but where i am running the DISPLAY portion by accessing the buffer, the FIRST-OF() or LAST-OF() does not work. even if...

Thanks "RealHeavyDude". Heavily appreciate your responses. :)

One small help... Is it possible to use FIRST-OF or LAST-OF condition during display. if yes then how to do that because i am keep on getting error.

Thank you so much "RealHeavyDude". It worked.

My code has been attached. Now problem is in the display portion i am able to get the scope of the last buffered table. in my case _field is only getting accessed. But i want both _file and _field to be within scope of the display. appreciate your response.

Thanks all for the response. Finally i managed to put this in dynamic query. But my problem is i have multiple table join in the dynamic query. And during the ADD-BUFFER process, all the tables are overwritten to the buffer by the last table buffer. Hence i am getting output for the last table...

I tried the below query. define variable m_db as character no-undo. update m_db with frame a side-labels. create alias qad for database value(m_db). for each qad._file where _file-name = "xx_gvs_det" no-lock: disp qad._file with 2 col width 200. end. In this case i am getting the below error...

Hey Cringer, Thanks for the quick response. Could you please provide an example for this. Appreciate your support.

Hi guys, I have 3 dbs connected such as "abcd.db" "abcdu.db" and "utlcomu.db". these are the logical names and abcd.db contains all the standard QAD tables where as abcdu.db and utlcomu.db contains customized tables. Now in a query i am taking input as the table name to search the fields. By...