form w/ embedded browse jpeg field = jpeg field

[reedorbs]

I have a form with an embedded browse with the following code in the onrowdblclick event. I have a jpeg field in the browse and want to copy the picture to a jpeg field on the form. The line with the comment "this does not work" is what I have come up with after searching the forum and other resources on Alpha5 helps. Any help with this would be appreciated.

temp=CATBROWSE.active() 
temp2=eval("CATBROWSE:" + temp + ".text") 'CHANGED TO TEXT
topparent:TEMP_MEMO.value=details.value 'this works
topparent:TEMP_PIC.value = a5_get_jpeg(pic.value) 'this does not work
end

[Stan Mathews]

Re: form w/ embedded browse jpeg field = jpeg field

topparent:TEMP_MEMO.value=details.value 'this works

topparent:TEMP_PIC.value = a5_get_jpeg(pic.value) 'this does not work

My take on the documentation is that A5_GET_JPEG() is used to display a dialog box. Did you try

topparent:TEMP_PIC.value = pic.value

[reedorbs]

Re: form w/ embedded browse jpeg field = jpeg field

I used that code at first and it didnt work. I have also studied the blob functions. Thanks for your reply.

[Stan Mathews]

Re: form w/ embedded browse jpeg field = jpeg field

I used that code at first and it didnt work. I have also studied the blob functions. Thanks for your reply.

Well, if it is any consolation, I can't figure it out either.

I was able to do something like what you want by

Place a bitmap on a form
Make the field in the child table browse an image reference field (not a jpeg field)
Populate the image field with bitmaps (not jpg files)
Make the onrowdblclick code bitmap1.bitmap.filename = browse1:pgj.value where pgj is the fieldname of the image reference field

Still looking into it.

[reedorbs]

Re: form w/ embedded browse jpeg field = jpeg field

Thanks for your reply and study time. I have been testing near something like you suggested. Will use what you added to see if it works. Thanks again.

[Stan Mathews]

Re: form w/ embedded browse jpeg field = jpeg field

Thanks for your reply and study time. I have been testing near something like you suggested. Will use what you added to see if it works. Thanks again.

I did notice that when I tried to populate the image reference field with jpg images and then use the same code to change the image shown in the bitmap field, the first record in the child table would replace the shown image when double clicked. Subsequent double clicks would, in the debugger with debug(1) preceeding the attempt to assign the image reference field value to the bitmap object, throw an error1 which I took to mean that the referenced image was not found. Very strange and I intend to delve further into the reason.

[reedorbs]

Re: form w/ embedded browse jpeg field = jpeg field

With your code I came up with this code. The picture copies to the form's bitmap image. Now I need the code to copy to the form's parent table's field.

temp=CALBROWSE.active()
temp2=eval("CALBROWSE:" + temp + ".text") 'CHANGED TO TEXT
topparent:TEMP_MEMO.value=details.value
topparent:bitmap1.bitmap.filename=Picref.value
'topparent:temp_memo.refresh()
end

On both the details and the Picref fields I have had to put a field from the browse on the form.

This is what I have come up with so far to get the bitmap into a jpeg field and I also tested with the field Mon1_pic as a image reference field. The code does not work.

topparent:Mon1_pic.value =ui_get_image_filename(Picref.value)

Thanks for your help.

[Stan Mathews]

Re: form w/ embedded browse jpeg field = jpeg field

With your code I came up with this code. The picture copies to the form's bitmap image. Now I need the code to copy to the form's parent table's field.

temp=CALBROWSE.active()
temp2=eval("CALBROWSE:" + temp + ".text") 'CHANGED TO TEXT
topparent:TEMP_MEMO.value=details.value
topparent:bitmap1.bitmap.filename=Picref.value
'topparent:temp_memo.refresh()
end

On both the details and the Picref fields I have had to put a field from the browse on the form.

This is what I have come up with so far to get the bitmap into a jpeg field and I also tested with the field Mon1_pic as a image reference field. The code does not work.

topparent:Mon1_pic.value =ui_get_image_filename(Picref.value)

Thanks for your help.

Try

topparent:Tables:[COLOR="Red"]YourTableNameHere[/COLOR]:Mon1_pic.value =ui_get_image_filename(Picref.value)

[reedorbs]

Re: form w/ embedded browse jpeg field = jpeg field

The last code that I suggested along with your code suggestion put the action of my mon1_pic field asking for a choice of file names. I would like the on event of another field in this instance called Mon1 to trigger the bitmap that your code filled to fill the jpeg field to be filled.


topparent:MON1.value = temp2 'form field
topparent:MON1_MEMO.value = TEMP_MEMO.value 'form field
topparent:Mon1_pic.value = a5_get_jpeg(topparent:bitmap1.value) 'form field


This code returns the following error:

Invalid data-type for this operation



Thanks again Stan

[Stan Mathews]

Re: form w/ embedded browse jpeg field = jpeg field

The last code that I suggested along with your code suggestion put the action of my mon1_pic field asking for a choice of file names. I would like the on event of another field in this instance called Mon1 to trigger the bitmap that your code filled to fill the jpeg field to be filled.


topparent:MON1.value = temp2 'form field
topparent:MON1_MEMO.value = TEMP_MEMO.value 'form field
topparent:Mon1_pic.value = a5_get_jpeg(topparent:bitmap1.value) 'form field


This code returns the following error:

Invalid data-type for this operation



Thanks again Stan

I think I'm lost, and wrong. If MON1, MON1_MEMO, and MON1_pic are table fields that you are trying to set the values for you would use lines like

topparent:Tables:[COLOR="Red"]YourTableNameHere[/COLOR]:Mon1_pic =ui_get_image_filename(Picref.value)

eliminating the ".value" from the assignment.

If I'm not close to what you are trying to do, you could attach a sample table with a description of the desired result.

[G Gabriel]

Re: form w/ embedded browse jpeg field = jpeg field

I am not quite clear on the question:
Are you trying to copy an image from a browse based on one table to a field in a form based on another table?

[reedorbs]

Re: form w/ embedded browse jpeg field = jpeg field

Thanks Gabrial for your reply,


Yes that is exactly what I'm trying to do. I have the image transfering to a bitmap on the form but cannot get it to the actual jpeg field in the table. The jpeg field is on the form.


Thanks

[reedorbs]

Re: form w/ embedded browse jpeg field = jpeg field

Gabriel,

Sorry for the mispell on your name.

[G Gabriel]

Re: form w/ embedded browse jpeg field = jpeg field

Reed:
I am sorry but I am still not clear on what you want to do. Browses and Forms aside, Are you transfering an image from one table to a different table? or from one field in a table to another field on the same table?

[reedorbs]

Re: form w/ embedded browse jpeg field = jpeg field

Gabriel,
I have a embedded browse in a form. I'm using the doubelclick event on the browse to transfer the image from the browse table to the form's table.

Thanks