>I have a view that has been confounding me for some time now. Here's what's (not) happening:
>
>
>Create sql view "V_CUSTOMERHAULER" as ;
> select customerhauler.haulerid, customerhauler.customerid, customerhauler.sent2host, ;
> customerhauler.sent2interface, hauler.haulername ;
> from dbf!customerhauler ;
> left join dbf!hauler ;
> on customerhauler.haulerid = hauler.haulerid ;
> where customerhauler.customerid = l_cust
>
>
>If I strip the code down to a simple select statement and run it, it will select 8 records (correct). If I use this as is, I get 0 records and when I try to insert a record (when setup to be writable), I get the message "cannot insert an empty row into the base table"
>
>
>I have created the view programmatically, graphically, using viewedit. I have gone so far as to rebuild each table by hand complete with new indexes. I have another set of tables that are identical except they contain destinationid - that view works wonderfully.
>
>I'm beginning to think my magnetic personality is getting too close to my hard drive! ;-)
Steve,
Writing l_cust as ?l_cust would help ?
Cetin