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,

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

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

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

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

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

For each update that contains a change in the datastructure I do the following: · Copy the file before you make the changes and rename the DB Table. For instance copy table 1 “customer.dat” -> table 9

What problem? Van: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io] Namens Sofija Verzonden: vrijdag 2 juni 2017 13:48 Aan: main@magicu-l.groups.io Onderwerp: [magicu-l] SpecialBatchOptions #-

#-1

In V9: in your table properties set Row Highlight Style to Frame Van: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io] Namens Gábor Bor Verzonden: vrijdag 2 juni 2017 13:15 Aan: main@magicu-l.

#chat

I think I prefer: StatusBarSetText('Ingelogd als: '&User(0)) Van: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io] Namens Frederik Soete Verzonden: donderdag 1 juni 2017 7:07 Aan: main@magicu-

We use this same thing, but it is not consistent. If you hover over the menu it disappears, clicking the main form it appears again. Gr Florian Van: main@magicu-l.groups.io [mailto:main@...

No, I checked that. And the activity monitor returned the correct name. Van: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io] Namens Brenda Bullorini Verzonden: woensdag 31 mei 2017 15:42 Aan:

I solved it by using one event parameter, populated with the column name but still... Van: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io] Namens Florian Groothuis Verzonden: woensdag 31 mei

I have an online table. I want to trigger an event when a user clicks a certain column. I used the activity monitor to see the name of the event and the control name. So far, so good. I created an eve

It only makes the correct return-virtuals, not the input-virtuals. Too bad... Met vriendelijke groet - With kind regards, Florian Groothuis Analist/programmeur +31 (0)6 21927914 meilink.eu Meilink Beh

Today I tried to use the APG-button in de DirectSQL-screen, but I can't see the additional value. Here's the statement I want to implement: SELECT TOP(1) Waarde FROM ST_StaffelsPCF WHERE Vestiging= N'

I used Virtuals to init the LinkCreate. Using the fields from the link didn’t work, so an APG wouldn’t work. Met vriendelijke groet - With kind regards, Florian Groothuis Analist/programmeur +31 (0)6

And found the problem. I placed the result in a Alpha15, but the SQL-field is defined as Alpha4. So Magic fills the remaining positions with NULL() instead of CHR(32). Changing my virtual to Alpha4 so

No it doesn’t. I use a DirectSQL-statement to load a memory tabel. Using this statement: Select Artikel.PartGrpCode,Artikel.PartCode,Artikel.Description From dbo.T_Part as Artikel inner join dbo.T_Par

Adding is not the problem, all calls still work. What about deleting one... I would do nothing and adjust it when I encounter one. Met vriendelijke groet - With kind regards, Florian Groothuis Analist