Insert *

Results 1 to 4 of 4

Thread: Insert *

  1. #1
    Steevo Guest

    Default Insert *

    I am trying to add a record to a visual Foxpro database. The table has over 50 fields. I am wondering if there is a way to insert this record without specifying values for all the fields. Can this be done with wildcards, or some other method? Any insight is greatly appreciated.<BR>Thanks<BR><BR>Steevo<BR>

  2. #2
    Medieval Dude Guest

    Default RE: Insert *

    What if you placed NULL for the values?

  3. #3
    Join Date
    Dec 1969

    Default RE: Insert *

    No problem (for a SQL database, anyway) - the INSERT statement allows you to specify a list of field which you are inserting values into, eg:<BR><BR>INSERT INTO my_large_table (field1, field2, field25; field50)<BR>VALUES (value1, value2, value25, value50)<BR><BR>Fields which are not in the list will be set to their default values, or NULL if there is no default.<BR><BR>I&#039;ve never used FoxPro, so I&#039;ve no idea whether this is appropriate.<BR><BR>Dunc

  4. #4
    Steevo Guest

    Default RE: Insert *

    I have tried your suggestions. I think my problem is that most of the fields are required, as this table is part of an SBT accounting package. I think I need to deal with every field in some way... I was hoping I could do this with wildcards or some other &#039;blanket&#039; method.. any further thoughts?

Posting Permissions

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