Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>>>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) .
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement