General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>>>hmm i have a SELECT (whatever ) into () Table Greater.
>>>>Is that what is doing the new table?
>>>>when i press the button it does in truth and in fact tell me the table exsist and if i want to overwrite it
>>>
>>>Yes, it creates a new table every time. Use SET SAFETY OFF to avoid the question.
>>
>>hmm avoiding the question is not what i wanna do.I dont want too overwrite the table. so should i just use locate?but locate is slower cause the table isnt index. soo how else do i enter my data into my tables :( stuck again :P
>
>Ken,
>
>Let's start again from the beginning. Please give me an overview (in English) of what you're trying to accomplish (not just 2 sentences, but a complete description of the problem), then we will be able to give you some advices of the best ways of getting it done.
ok i had table addition and greater.Then when i pressed a button my program it would
A) populate the Greater Table (using select)
B) check if the name is already in the Addition table and if it isnt add it and send me a message if its not (using seek)
I wanted too use Seek to search for a name in a table so as you told me i had to set the table order.
but thats going to be complicated since i use a select statement to populate the table Greater and thats overwrites the index i made.
i know i can use a locate but i want to populate the table some other way(cursor) .
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only