VB to connect the VFP database, query a date within the period of record, using DTPicker controls, DTshortdate
Adodc1. RecordSource="select * from the node temperature and humidity information table where date='" & amp; DTPicker1. Value & amp; "'", always quote data type error, how great god make?

CodePudding user response:

Try # wrapped up, single quotes for #,

CodePudding user response:

To see what your "date" field is the data type, what is stored,

Assumption is date/time types, save only the date (time 0) :

Where the date=# "& amp; Format (DTPicker1. Value, "yyyy - mm - dd) & amp; "#"

CodePudding user response:

After the popup missiing operand errors, this how to solve?