Nettalk Application Wizard generation error

[MikeR]

1.
If you import a mssql table into a clarion dictionary
if a field is nullable
softvelocity sets the initial value in the dictionary to NULL
when capesoft nettalk wizard generates the prodecure it generates code that sets the firld equal to NULL eg.
tab:suppId = NULL
this causes a compile error
2.
if a table has a relation to another table for a particular field and you set the field to must be in table in the dictionary
if you create an alias of that table
the capesoft nettalk generator causes a compile error when validating the the alias table field exists ,
to correct this you need to add the same  relationship in the dictionary on the alias table.

[Bruce]

Morning Mike,

regarding 1) - what does Clarion do with the value NULL in a desktop program? (if anything?

regarding 2) a small dict with an example of the structure you have in mind would be helpful - thanks.

Of course the wizard is just a "starting point" - it's trivial to correct any mistakes the wizard makes - but I'd like it to be as smooth as possible, so I do try and tidy up the edge cases when they are reported if I can.

cheers
Bruce

[MikeR]

Thx Bruce I haven't checked what softvelocity does with the null value in the windows generator.
but the correct syntax would be to use the "SETNULL" clarion built in function on that field. I understand this may not be as trivial as it sounds as you need to know if the target database supports this.

The problem is once the uncompiled code is generated you cant edit it
its in a grayed out area, not in an embed point that you can edit afterwards.

I will create a small dictionary to try show the second problem.
I don't think its got to do with sql. I will create it as tps files.
However this problem can also easily be overcome by duplicating the relationship on the alias.

[Bruce]

looking forward to the example Mike...

cheers
Bruce