Truncating information.

[vinyltap]

I have a fetch.find that locates an email address. It works fine except for a small subset of records where it is truncating the email address.

ex: if email is [email protected] it gets pulled xyz123@yahoo

Is there any particular reason why it would only do this for a some records but work fine for the rest?

Ken

[Stan Mathews]

Re: Truncating information.

No clue here as to what you are doing with the result of the .fetch_find() or how you are determining that it is truncated. Are you sure the display format of the result is enough characters to show the whole returned email address?

[vinyltap]

Re: Truncating information.

Here is what I'm doing;

dim RequestedItem_no as N
dim session.proposalDate as c
dim Email as C
dim Email_HTML as c
dim Offer_id as N
dim Temp_id as C
dim User_Id as N
dim tbl_source as P
dim tbl_dest as P
dim tbl_pull as P
dim myindex1 as P
dim myindex2 as P
dim myredirect as C

RequestedItem_no=Item_no
Email=session.User_Name
Date=date()
session.proposalDate=Date()

tbl_source = table.open("[PathAlias.ADB_Path]\swap_items.dbf",FILE_RW_SHARED)
tbl_dest = table.open("[PathAlias.ADB_Path]\swap_proposals.dbf",FILE_RW_SHARED)
tbl_pull = table.open("[PathAlias.ADB_Path]\members.dbf",FILE_RW_SHARED)
myindex1 = tbl_source.index_primary_put("Item_no")
myindex2 = tbl_pull.index_primary_put("Email")
myredirect = "Swap_Item_offer.a5w?Swap_Item_View_filter=Item_no="+ RequestedItem_no

tbl_pull.fetch_find(Email)
Temp_id=tbl_pull.User_id

convert_type(RequestedItem_no,"n")
tbl_source.fetch_find(RequestedItem_no)
'checks that its pulling the fields on the record in the table the below pulls
'the email of the one receiving the swap offer
'?"user_id # from fetch= "+ tbl_source.User_id+"<br>"
'?"wanted title from fetch= "+ tbl_source.title+"<br>"
'?"item number from fetch= "+ tbl_source.Item_no+"<br>"
'?"Initiator's Email="+ tbl_pull.Email+"<br>"
'?"Original requested Item number="+ RequestedItem_no

'end

tbl_dest.enter_begin()
tbl_dest.User_id=tbl_source.User_id
tbl_dest.Music_book=tbl_source.Music_book
tbl_dest.Title=tbl_source.Title
tbl_dest.Artist_author=tbl_source.Artist_author
tbl_dest.Year=tbl_source.Year
tbl_dest.Serial_no=tbl_source.Serial_no
tbl_dest.Media=tbl_source.Media
tbl_dest.Quality=tbl_source.Quality
tbl_dest.Original_cover_art_sleeve=tbl_source.Original_c
tbl_dest.Original_accessories=tbl_source.Original_a
tbl_dest.Music_book=tbl_source.Music_book
tbl_dest.Description=tbl_source.Descriptio
tbl_dest.Email=tbl_source.Email
tbl_dest.Item_no=tbl_source.Item_no
tbl_dest.Offer_id=Temp_id
tbl_dest.Type=tbl_source.Trade
tbl_dest.Date=date()
tbl_dest.enter_end(.T.)

email_send(tbl_source.Email,"New Swap Offer!!",Email_HTML,"",tbl_pull.Email,"",.F.,"HTML",Email_HTML,"kboucher")

[Stan Mathews]

Re: Truncating information.

There's nothing in your code that would truncate an email field. Are all email fields defined the same width in the tables?

If this is your entire code you need to close the tables somewhere

tbl_source.close()
tbl_dest.close()
tbl_pull.close

when the script is done.