Ok..well then I'd say I don't...however there are 3 fields in the mySQL table that have a field type of 'tinytext' - which I made memo fields in the view...not sure what tinytext is but it looks like a memo field to me.

*------------------------------------------*
SELECT Orders.id, Orders.member_id, Orders.date, Orders.first_name,;
Orders.last_name, Orders.company_name, Orders.email,;
Orders.streetaddress, Orders.streetaddress2, Orders.city, Orders.state,;
Orders.zip, Orders.province, Orders.country, Orders.home_phone,;
Orders.work_phone, Orders.ship_first_name, Orders.ship_last_name,;
Orders.ship_company_name, Orders.ship_email, Orders.ship_streetaddress,;
Orders.ship_streetaddress2, Orders.ship_city, Orders.ship_state,;
Orders.ship_zip, Orders.ship_province, Orders.ship_country,;
Orders.ship_home_phone, Orders.ship_work_phone, Orders.card_type,;
Orders.card_number, Orders.card_exp, Orders.card_name, Orders.cc_code,;
Orders.transid, Orders.products, Orders.product_options,;
Orders.product_ids, Orders.product_qtys, Orders.product_totals,;
Orders.product_prices, Orders.subtotal, Orders.discount, Orders.tax,;
Orders.shippingprice, Orders.grandtotal, Orders.shippingtype,;
Orders.exported_to_mom, Orders.order_comments, Orders.order_status,;
Orders.browser, Orders.timestamp, Orders.source_key;
FROM ;
orders Orders;
WHERE LEFT(timestamp,8) < = ( ?lcDate )
*------------------------------------------*

>No, I meant expression in the field list which is not of fixed size.
>
>>I do have this in the view:
>>
>> WHERE LEFT(timestamp,8) < = ( ?lcDate )
>>
>>...I take it you think this is my problem?
>>
>>>Do you have calculated fields in the view?
>>>
>>>>I have a remote view to a mySQL database.
>>>>
>>>>If I do this:
>>>>
>>>>myParameter = 'blahblah'
>>>>Use myRemoteView
>>>>
>>>>...everything works fine, I see data in the view.
>>>>
>>>>
>>>>but, if I do this:
>>>>
>>>>myParameter = 'blahblah'
>>>>Use myRemoteView in 0 NODATA
>>>>lnQResult = Requery('web_orders_bydate_rvwpu')
>>>>
>>>>...I get an error saying 'view definition has been changed.'
>>>>