Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. knopmike

    Requerying Backend Data.

    I have a form that uses a pageframe object such that a remote view is associated with each page. I've implemented code such that on the activate of the page, I select the view associated with it and do a requery (the goal is to have current data). Everything appears to work ok except when I...
  2. knopmike

    NetUserGetGroups

    Does anyone have any experience using the above win32 netapi32 function in vfp? If so could you provide an example. I'd like to be able to return groups that a user belongs to on a win2k server that is a domain controller of an active directory. Thanks. Mike
  3. knopmike

    Visual Fox 6, Sql Server 2000, and Security.

    I'm migrating some corporate applications from vfp 6 front and back to vfp 6 front and sql2k back and don't have time to redesign security from the ground up. Currently (vfp front and back) we use 3 netware groups (ro - read only, de - data entry, ad - admin) for every app; when the app runs...
  4. knopmike

    Error Number 1491.

    Thanks for the posts. I'm not using ado, but rather odbc. I got side-tracked for a few days, but am now back on this. Will take the above advice and see what I come up with. Mike
  5. knopmike

    Error Number 1491.

    I'm receiving the above error when I click on the exit button of my form; even if i didn't add, delete, create, or read a record. I manually opened and ran every view used in the form and manually everthing seems ok. I stepped through the code after clicking the exit button and the error comes...
  6. knopmike

    re-activate a form

    You could also explicitly call the form's activate event after the do prg: click code do prg thisform.activate() Mike
  7. knopmike

    Changing Collation.

    Thanks for your help, however I don't have much experience writing scripts and it would take a long time to create a script for every column of every table of the databases I need converted. Any additional help anyone could provide would be appreciated. Thanks. Mike
  8. knopmike

    Changing Collation.

    I have a few databases that were imported from another SQL Server 2000 that I need to change the collation sequence for. I'm aware of the alter database command, but after executing this command, the database collation changed but all of its tables still had the old collation sequence. Is...
  9. knopmike

    VFP 6 data Upsized to SQL 2000.

    When I run my app and click on the menu that causes my 'do form ...', code to run, i get the following error message below: Application Error! Error: 2005 - Error loading file - record number 10. Frmnebscreen1 <or one of its members>. Loading form or the data environment: Connectivity...
  10. knopmike

    Saving Nulls to SQL Server.

    Dedmod, When the app was file based, the form was based on a local view. When the dbc was upsized using the sqls wizard, i instructed the wizard to automatically created remote views based on the local tables and views. So now the form is based on a remote view, such that the custom date...
  11. knopmike

    Saving Nulls to SQL Server.

    Thanks for a quick response guys i appreciate it. Dave, Thanks for the idea of the rule on the sqls table(s) - i'm sure that would ensure that date fields either have a date or are null. Ideally it would be great to have a solution on the vfp side, but if its not possible, then I may have to...
  12. knopmike

    Saving Nulls to SQL Server.

    I've upsized a vfp 6.x dbc to sql server 2000 and am having a problem with dates. Null date fields in vfp migrate to sql server with no problem. Our forms use the ms common calender control wrapped around a textbox and button so that when a user clicks the button, the calendar comes up, a...

Part and Inventory Search

Back
Top