Newbie Question! :)

[Tony]

Hello everyone. Im VERY new to progress, and am in desperate need of help!

Our former programer has left us high and dry with an out of date database. I know a little about sql and have been able to query the system and build a CSV file to update one field in our system (customer Level)

What i need to do is write a procedure to compare the customer number to the Level, and change those that do not matchthe CSV file i have created

could someone please help me out!
i want to learn progress but not like this! hehe (the system is suposed to go live next week! )

Thanks in Advance

Anthony

 

[Unregistered]

I'm not sure what you are asking here. Do you want a procedure to update a Progress database with information from a CSV file? If so, then you should have something like this:

DEFINE VARIABLE cCustCode AS CHARACTER.
DEFINE VARIABLE iLevel AS INTEGER.

INPUT FROM customer.csv.
REPEAT:
IMPORT DELIMITER "," cCustCode iLevel.
FIND Customer WHERE Customer.CustCode = cCustCode
EXCLUSIVE-LOCK NO-ERROR.
IF NOT AVAILABLE Customer THEN NEXT.
Customer.Level = iLevel.
END.

If not, please let me know what you are trying to accomplish.

 

[Tony]

That was exactly what i needed thank you very much

But i have one more problem. When i try to check syntax after updating tablenames and such i get

"You may not compile programs that update the database in this version (490)"

What do i need to fix this?

Thank you
Anthony

 

[Unregistered]

Unfortunately what you need is a different version of Progress. You seem to only have a run time license. You need to have some type of development license to compile programs that update the database.

Sorry about that.

 

[Tony]

DAMN that means our previous developer ran off with whatever we need!

Is there any way to get this to work? we need to update this ASAP

Could someoen compile this for us or something along those lines?

I really appreciate your help,

anthony

Ps unfortunatly we use progress 8.3c which i dont think we can even buy any longer. So i am unsure of what to do at this point!
any suggestions?


I guess ill have to try ODBC connectivity, any one know if this is gona work?

Thanks

 

[Tony]

I GOT IT

thank you guys for all your help

I eneded up going back to what i know (POS access haha)

Opening the Progress Database thru ODBC and runing an update query against the progress database!

Im so stoked, and i want to say thank you for your help!

Anthony