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
, Currency
I 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...