Results 1 to 2 of 2

Thread: Field type problem

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    May 1999
    Location
    Reynosa, Mexico
    Posts
    274

    Post

    I get an error when I try to save a data in a date field of visual FoxPro from VB. I have tryed qith VB variables type date, string and text. If I put the complete date including its separator characters ("08/12/99"), I get an error: 'Invalid character'. And if I quit its separator characters ("081299"), I get an error: 'Incorrect type for parameters'.

    Does FoxPro perform any kind of conversion or transformation of the data to storage in another format or something?

    Do you have any idea of whats happening or how to solve this problem?

    Thanks!

    Ulises


  2. #2
    Lively Member
    Join Date
    Jan 1999
    Posts
    81

    Post

    Make sure your using the correct database type. If you have foxpro 3.0 databar and its a foxpro 2.5 the date will be null since the program is trying to send the wrong conversion string.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width