RE: [sqr-users] ERROR (SQR 1303 and 1304) and a Virtual Table

[don.barclay@srs.gov]

Hi Janet,

One way around this problem would be to create a custom view that would 
include the customer id and their description if it exists.  The view 
could use an outer join or a union to achieve this.  That would simplify 
the SQL in your program, and would allow you to sort by the customer 
description.

Don

> I am fairly confident that the date format is not the problem, but
> rather somehow the syntax of the virtual table in the left outer join.
> Therefore, I have restructured my program to execute a GetCustomerID
> which does a call to GetCustomerDescr.  This is not ideal in the long
> run, because I will not be able to sort by CustomerDescr but will get
> this out to production for my users until I can resolve the left outer
> join problem.  Thanks for your prompt response to my dilemma. 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users