Of course. And destination tables to Write/None. Met vriendelijke groet - With kind regards, Florian Groothuis Analist/programmeur +31 (0)6 21927914 meilink.eu Meilink Beheer Borculo B.V. • Kamerlingh

This could depend on a lot of things: - What DB are you using? - How do you determine Last OrderID? - How did you define your DB-tables in your program? Gr Florian Van: main@magicu-l.groups.io [mailto

#-1

If you swich to create mode and determine your OrderID the record is not written yet. So when the record ís written it is possible that another user created a new order too but was earlier with saving

#-1

Nope. In older versions we used the border, in later versions the BG-color. I think the BG-color makes the border obsolete. Van: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io] Namens Gábor B

#chat

How can I populate either a combobox or a select task with a SQL-statement? I have a program that let's the user answer a list of questions. Some answers should be selected from a query from the DB. O

That won’t work because the requirement statement can’t be captured in the range-option of the DataSource option. Defining a separate view isn’t an option. Met vriendelijke groet - With kind regards,

This could work except when the results are numeric values. Casting them as alpha-numeric values messes up the ordering, when I use a numeric virtual as output variable I get this: Van: main@magicu-l.

Ok, fixed it. Output had to be Float8. Thnx! Met vriendelijke groet - With kind regards, Florian Groothuis Analist/programmeur +31 (0)6 21927914 meilink.eu Meilink Beheer Borculo B.V. • Kamerlingh Onn

I got it right, see my previous message. And yes, indeed, it would be nice if we could do so. Gr Florian Met vriendelijke groet - With kind regards, Florian Groothuis Analist/programmeur +31 (0)6 2192

If you use an “order by” on converted numerics you get this 14,40,7,9. Should be 7,9,14,40 as numeric. I solved this issue by making 2 subtasks, numeric and alphanumeric, and sending an additional par

I have to in order to get the numbers without decimals. Van: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io] Namens Andy Jerison Verzonden: woensdag 14 juni 2017 13:37 Aan: main@...

I have to correct that. I have statements with alphanumeric and numeric results so it was either convert or split up. Met vriendelijke groet - With kind regards, Florian Groothuis Analist/programmeur

You can’t when you use the distinct function: SELECT distinct Height*1000 From dbo.T_Part Where PartObsInd=0 and QualityCode = 'K' I could do this: SELECT distinct Height, CAST(Height*1000 as Char(12)

I deleted this topic. It’s solved. Met vriendelijke groet - With kind regards, Florian Groothuis Analist/programmeur +31 (0)6 21927914 meilink.eu Meilink Beheer Borculo B.V. • Kamerlingh Onnesstraat 1

I use the Return Value when I call the program by expression on a edit field. In that case the value is visible ánd in a table view the value is conform the record on the table row. Met vriendelijke g

The wrong variable was used. Met vriendelijke groet - With kind regards, Florian Groothuis Analist/programmeur +31 (0)6 21927914 meilink.eu Meilink Beheer Borculo B.V. • Kamerlingh Onnesstraat 1 7271

Let’s say I have a table with products and a program that calculates the actual stock. If I use a virtual, send it as a output parameter to that program and place that virtual in the table it shows th

What are you trying to achieve? You can also use Outer Join instead of Inner Join. Van: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io] Namens Lado Wali Verzonden: woensdag 21 juni 2017 22:56

If a virtual has changed which is part of the dataview the RS is also processed. Using VarMod let’s you determine whát has changed. Met vriendelijke groet - With kind regards, Florian Groothuis Analis

I wanna jump in on this one: I never use DirDlg() or FileDlg directly on a variable but always an extra variable. If you do an update on a variable with DirDlg() and the user presses ‘Cancel’ the orig