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! ;-)