S
Smokus
Guest
I am having issues with a programm where I need to output different strings if a certain Database Field has a specific value.
Let's say I have a Database called
I am outputting the data into a .csv File so my company uses for that a lot of
The "output" part would look something like this:
The problem with these
I tried in multiple ways, but failed every time. Could someone help me out please?
Continue reading...
Let's say I have a Database called
TestDB with following Fields Name, Age, CurrencyI am outputting the data into a .csv File so my company uses for that a lot of
put unformatted statements.The "output" part would look something like this:
put unformatted
TestDB.Name ';'
TestDB.Age ';'
if TestDB.Currency = 1 then 'Euro' else ? ';'
if TestDB.Currency = 2 then 'Dollar' else ? ';'
if TestDB.Currency = 3 then 'Kuna' else ? ';'
if TestDB.Currency = 4 then 'Pound' else ?
skip.
The problem with these
if's is that if Currency is 1, it will output Euro, but for other if's still output ? in .csv File. I want these if's to be structured like: if... else if... else if... else So if the 1st if is correct, then all other if's would be skipped.I tried in multiple ways, but failed every time. Could someone help me out please?
Continue reading...