I think this is what is happening. I am executing or trying to execute
very long SQL statements in my VB app but now I am running into the
physical limits of VB's String type. Does anyone know a work around?
Here are some of my code segments:
sReturn = "SELECT BillPeriod, BilledNumber, CallDate, ConnectTime, " & _
"RateClass, FromNumber, FromPlace, CalledNumber, " & _
"CalledPlace, CallDuration, Minutes, " & _
"CallCount, Amount, DataFileName as 'Source' " & _
"FROM Data "
sReturn = sReturn + "WHERE BillPeriod = '" & sBillingPeriod & "'"
sReturn = sReturn + " AND (CallDate BETWEEN #" & Format(tbFromDate.Text,
"mm/dd/yy") & "# AND #" & Format(tbToDate.Text, "mm/dd/yy") & "#)"
If I use a SELECT * in place of the long SELECT statement shown above
everything works fine but when I try to use the SELECT statement shown
above my SQL statement gets cut off.