What do you mean by bloat in the dbc?

We did this because we are refreshing the data. What is the best way to refresh the data?

Jim

>Yes but still no need and would cause a bloat in dbc.
>Cetin
>
>>My mistake, I forgot to type the create view clause....
>>
>>
>>Jim
>>>>I'm trying to create a view based on a string and using the Execscript function, but it's not working and I don't know why. The error message is Syntax Error on the execscript function. Please take a look...
>>>>
>>>>

>>>>	LOCAL lcScript, lcStartDate, lcEndDate
>>>>	IF USED("deliveries")
>>>>		SELECT deliveries
>>>>		USE
>>>>		DROP VIEW deliveries
>>>>	ENDIF
>>>>	lcStartDate = ALLTRIM(STR(YEAR(Session.startdate))) + "-" + ;
> ALLTRIM(STR(MONTH(Session.startdate))) + "-" +;
> ALLTRIM(STR(DAY(Session.startdate))) + ' 00:00:00'
>>>>	lcEndDate = ALLTRIM(STR(YEAR(Session.EndDate))) + "-" + ;
> ALLTRIM(STR(MONTH(Session.EndDate))) + "-" + ;
> ALLTRIM(STR(DAY(Session.EndDate))) + ' 00:00:00'
>>>>	lcScript = "SELECT * FROM Deliveries"+ ;
>  " WHERE Deliveries.deliverydate >= "+;
>  "cast('" + ;
>  ALLTRIM(lcstartdate) + ;
>  "' as datetime) AND deliveries.deliverydate <= cast('" + ;
>  ALLTRIM(lcenddate) + "' as datetime)"
>>>>	EXECSCRIPT(lcScript)
>>>>	IF !USED("deliveries")
>>>>		USE deliveries IN 0
>>>>	ENDIF
>>>>

>>>
>>>Jim,
>>>Good it errored (cast in script was the cause I think).
>>>This sounds to be a preparation for SQL server. Instead of dropping, recreating (no recreation code there but I think you intended it) create a parametric view in the first place:
>>>
>>>

>>>create sql view deliveries ;
>>>  remote connection myConnection ;
>>>  as ;
>>>  select * FROM Deliveries ;
>>>  WHERE Deliveries.deliverydate between ?ldStartDate and ?ldEndDate
>>>

>>>
>>>ldStartDate = Session.startdate
>>>ldEndDate = Session.enddate
>>>use myDbc!deliveries in 0
>>>
>>>ldStartDate = date()-1000
>>>ldEndDate = date()
>>>requery('deliveries')
>>>
>>>Cetin