Re: Need to change back end to SQL

Thank you very much.

I tried cursoradapters and they work fine.

I am using the normal file handling commands to manipulate data for which I
need several indexes. I have seen that I can create 'Index Tags' during run
time which is taking a little time. Is there a way I can define 'Index Tags'
for cursoradapters during design time.

Thank you again.
Tanveer Ishaque.

"Lee Mitchell" <Leemi@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:%232NP2k64FHA.3936@xxxxxxxxxxxxxxxxxxxxxxxx
> Hi Tanveer Ishaque:
>
> Can you tell us a little bit more about how your application is designed?
> Are you using local views to populate your grids? If so, then simply
> change these to remove views that point to your SQL Server data. Since
> you
> have VFP 9.0, you can also use cursoradapters to connect to SQL Server.
>
> I hope this helps.
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> Sincerely,
> Microsoft FoxPro Technical Support
> Lee Mitchell
>
> *-- VFP9 HAS ARRIVED!! --*
> Read about all the new features of VFP9 here:
> http://msdn.microsoft.com/vfoxpro/
>
> *--Purchase VFP 9.0 here:
> http://www.microsoft.com/PRODUCTS/info/product.aspx?view=22&pcid=54787e64-52
> 69-4500-8bf2-3f06689f4ab3&type=ovr
>
> Keep an eye on the product lifecycle for Visual FoxPro here:
> http://support.microsoft.com/gp/lifeselectindex
> - VFP5 Mainstream Support retired June 30th, 2003
> - VFP6 Mainstream Support retired Sept. 30th, 2003
>
>
>>Hi
>
>>I have a very large application developed in VFP. Currently I am using a
> VFP
>>database. I need to change the back end to a SQL server. I am using VFP
> grid
>>extensively in almost all programs. What would be the best way to switch
> to
>>SQL Server.
>
>>My application runs smoothly in VFP9.
>
>>Thanks in advance.
>
>


.

Relevant Pages

  • Re: VFP 9: Parametrized views and Rushmore speed
    ... don't forget that starting in VFP 8.0 we added cursoradapters. ... If table fields are indexed according to fields used to filter records in ... anymore in VFP9 with its new Grid.Optimize property). ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Need to change back end to SQL
    ... > I am using the normal file handling commands to manipulate data for which ... I have seen that I can create 'Index Tags' during ... > for cursoradapters during design time. ...
    (microsoft.public.fox.vfp.dbc)
  • Re: The best way to handle data?
    ... migrate the app to SQL Server. ... I remember a while ago that everyone was suggesting using them. ... I have been thinking about changing our views to cursoradapters for our final VFP release, (since we use a common data object for ALL data access it would be easy to do, the hardest part would be generating the cursoradapters and I understand that not that hard either) but don't want to spend any time doing so if there is no advantage to it. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: The best way to handle data?
    ... I haven't used CursorAdapters, so can't say to use them or not. ... advantage over Views is that you can use OLEDB rather than ODBC to access ... to migrate the app to SQL Server. ...
    (microsoft.public.fox.programmer.exchange)
Loading