Hi,everyone. Can anyone help me with this-I have a form set opened with two tables on it & one variable where I enter barcode. I would like to search for that barcode in tbl2 and when/if found-move it to tbl1. If the search doesn't find anything then just add the barcode from variable to tbl1.
-
Re: Move rec from one tbl to another...
I don't think you need to use a set based form for this.
Using a form based on Tbl1 you could put a button on it which:
a) uses find by key to do an indexed search for the barcode in tbl2
b) if found, assigns field values from the found record to the fields in the current record displayed in the form
c) if not found assigns only the barcode value (from your variable) to the relevant field displayed in the form -
Re: Move rec from one tbl to another...
Maybe I explained this too simple. In Tbl2 I have all barcodes of lets say products-about 100.000 of them. I need a quick way to scan a product(it's barcode is written in Var1) then to search in Tbl2 for that barcode,if found copy-to-Tbl1-erase, if not copy Var1 to Tbl1.
In Clipper S87 I did it very easy...
do while !eof
seek var1
iffound Tbl1(field)=Var1
delete record
else
Tbl1(field)=Var1
endif
enddo
But in Alpha I cannot make operations or functions to work. Further more I cannot use any additonal buttons because I work only with scanner so all events must be like 'on arrive' or 'on depart' (got focus & lost focus) on field.
Please give me some advice.Comment
-
Re: Move rec from one tbl to another...
Hello again.
I thought you wanted to "move" field values from tbl2 into a record in tbl1 if the barcode value in your variable was found in tbl2. What exactly do you mean by:
copy-to-Tbl1-erase
The clipper code doesn't do any copying. Or am I missing something here?
-- tomComment
-
Re: Move rec from one tbl to another...
Here's an example that illustrates what I think you're talking about, except it runs from a button, not from a barcode scanner. Hope it gives you some ideas.Comment
-
Re: Move rec from one tbl to another...
Zeljko,
Expanding on Tom's suggestion.
Most bar code scanners allow for a pre-amble or a post-amble(is that a word?). These allow you to send control instructions to the receiving form. These are received by the form as standard keyboard key strokes.
In a preamble you could send say a function key or alt + function key then program the OnKey event of the form to trap these 'key strokes' to run the code Tom has provided.
Or in a post amble you could send the Enter or tab key. Make sure there is another object on the form that can receive the focus so the barcode field is able to be departed. Put the code in the OnDepart event of the Barcode field. The last bit of your code could set the Barcode variable to "" and return focus to the barcode field.
Tom,
I think what Zeljko wants with "copy-to-Tbl1-erase" translating to your example is that if a record is found in the supporting table and subsequently copied to the master that it is then deleted from the supporting table.Tim Kiebert
Eagle Creek Citrus
A complex system that does not work is invariably found to have evolved from a simpler system that worked just fine.
Comment
-
Re: Move rec from one tbl to another...
Hello, Tim.
Deleting the found record in the supporting table would be an easy thing to add to my example. Let's see if he can handle it or needs further assistance.
-- tomComment
-
Re: Move rec from one tbl to another...
Hi Tom, Agreed!Tim Kiebert
Eagle Creek Citrus
A complex system that does not work is invariably found to have evolved from a simpler system that worked just fine.
Comment
-
-
Re: Move rec from one tbl to another...
Ok guys I managed to delete found record. But the first look on the example you sent tells me that I am going the wrong way from the beggining. First of all you have a form which is not directly linked to any table,but to empty table dummy-I was doing wrong,always creating form based on the tableset or table itself. I prefer your way, it's much safer for data.
Can I please attach my project as a zip file in order for you to point me in the right direction. I have to point out that I'm not asking you to do programming for me, just explain me what to do and I will find how to use the code. Although I'm using Alpha for three weeks now you would be surprised what I managed to create so far.(I have some experince with Clipper,Access and VB5/VB2005).
Thanks in advance & thanks for this example.Comment
-
Re: Move rec from one tbl to another...
Are you sure you attached the correct project? This one looks like Tom's example.Tim Kiebert
Eagle Creek Citrus
A complex system that does not work is invariably found to have evolved from a simpler system that worked just fine.
Comment
-
Re: Move rec from one tbl to another...
well of course it looks the same, but if you check table 'supporting' you'll see that it is deleting the selected barcode. You can also check code on the buttonpush event where I added:
tbl2.change_begin()
tbl2.delete()
tbl2.change_end(.t.)
in order to delete found record.Comment
-
Re: Move rec from one tbl to another...
Zeljko, I think Tim and I were expecting you to attach your project, since you said:
Your modifications to the script look fine. However, you're deleting the record before the new record is committed to the Master table. This assumes the commit won't fail. If I were writing production code, instead of simple example to get you going, I'd include error trapping around the writes to the Master table, and would not delete the "found" record until the commit finished without throwing an error. You probably have experience doing this sort of thing in Clipper. Read the help topics on Error / Handling, and <tbl>.enter_end() for details about how it's done in Alpha FiveCan I please attach my project as a zip file...Comment
-
Re: Move rec from one tbl to another...
:D Yeh, I did See that but like Tom said I thought we were going to get a peek at your effort. So we could see your problem in your context. Much easier to make recommendations if we see what you see. Check out the capability of the scanner you are using or planning to use as far as the pre or post amble. I think that is one of the key things that will determine how you proceed with coding. Start reading up on the OnKey form event. Personally, if possible I would use the post-amble and the OnDepart event as described in my earlier post. This is a case were getting the right hardware(ie scanner) for the job will be half your battle.Originally posted by Zeljko View PostTim Kiebert
Eagle Creek Citrus
A complex system that does not work is invariably found to have evolved from a simpler system that worked just fine.
Comment
-
Re: Move rec from one tbl to another...
What about my suggestion that I zip my project and you see what I did so far. What ever you think I should change, just tell me and I will try to change. I also have some ideas but I need advice how to do it. I have two projects. This previous problem with deleting selected barcode is No2. Project No1 is POS (Point Of Sale) program.I would like to ask you to see this and give me few advices. Maybe if other members check this thread they can also advice me....What do you think about it?Comment
Comment