Tag Archives: Flynet
Where Clause
Flynet: WHERE clause is only for parameters, (inner) joins defined in FROM clause.
Source & Output folder
Flynet: Place source files and output folder of your Webservice directly on c drive and not in a “my documents” folder. (in case use of local host and IIS).
Parameter
Flynet: Webservice parameter stated as “in_” en Direction=”IN” string notation = table.fieldname=’~in_name~’ number notation = table.fieldname=~in_name~ List Number parameter type is string thus WHERE table.fieldname in (~in_name~) [Type = "string", Direction ="IN"].
Insert, update and delete statements
Flynet: Insert, update and delete statements work according to same principle as normal select statement.
Fieldnames must be unique
Flynet: Output columnnames have to be unique, in aggragations thus: SELECT (~field1~*field2) as alias, (field1*~field2~) as alias2 FROM …. OR SELECT (field1*field2) as ~alias~, (field1*field2) as ~alias2~ FROM …. AND NOT LIKE SELECT (~field1~*field2) as alias, (~field1~*field2) as alias2 FROM … Continue reading
Error 2869
Flynet: This is a known issue for non-English versions of windows and will be fixed in the next release of our Web Service Generator (version 1.6). In the meantime you can download and install a special version from: http://www.flynetviewer.com/Downloads/WSGd/Special/Setup1_5_33.zip
