Recent content by bbrendan

Hi all, Just in need of some help in creating a variable number of export files from a database. The reason is i have a limit of the number of rows that each file can contain. in this case 3000 rows per file. I can create the file ok, but im having trouble dropping 3000 records into each...

that would rely on you having outlook running all the time. since outlook is only a "mail client" if for example you were on holidays, the mail sent from SAP would sit in your mail server until you returned and opened outlook. Which would then action your code.. if you canb code in VB, i would...

Its not very straightforward!. I have been down this road before. Wanting to build a qry and have it run as a background job overnight to extract a report and dump it somewhere. if you look on sdn.sap.com/forums you will see a number of posts in regards to how to set this up. From what i recall...

Ah..., i see your issue. This type of report to the best of my knowledge cannot have a layout variant saved. One alternative approach is to write an infoset Qry/ SAP Query using this same table Use a ALV grid as the output this will allow you to save a layout variant. We have done this for...

ok, if you dont have an SAP OSS signon, you cannot get to the SAP connector. there are alternative products on the market. ive used on from these guys. http://rfcconnector.com/ its costs a little but its pretty good and does work with vb2005. It also has some neat tools for creating idocs...

also, what about using SAP Query or Quick Query (SQ01) you could write custom reports (info sets) save them and run as a batch job via SM36 other ideas! cheers

you cannot access SAP tables via odbc. use the SAP .net connector look on SAP for this. Its an addin that allows you to make BAPI calls, ie: query some of the tables like customer master and material master. if you look in SAP run TCode BAPI and you will see all the BAPI's you can run...

yes there is. Variants by default cannot be saved unless you have the correct settings on your user profile transaction code SU01 enter your user name Goto the parameters tab add the paramter ID SD_VARIANT_MAINTAIN and values : XXXX XXX XX cheers

ive done vb.net app's that make BAPI calls to SAP. There are some standard BAPI's in SAP to read tables like customer master, material master and sales orders. If you do a search on SAP for .net connector you will find there is a SAP.net connector for VB2003. Note: this is version 2.0 this...

Hiya, With regards to the crystal reports, you could publish these reports via crystal enterprise web application. Or am i not understanding your problem cheers

Hi gmmastros, Ive tried your change to the code but im still only getting the first row of data. Man this is thrustrating me :)

Hi All, thanks for you help on this really!. I will try your suggestions out. Regarding the text odbc driver, yes went down that path, but unless your using a common delimter like "," you hit some brick walls thanks again

Hiya Thanks for your help, still trying to get my head round this OK, so I have the following code that splits each line the splits inside that that as shown below. But it doesnt loop through each line only the first line. any help would be great Dim strTemp() As String Dim intLine As...

Hi all, im just i need of help with splitting a file The file looks like this ------------------------------------------------------------------------------- OrderID|BillFirstname|BillLastname|BillCompany|BillAddress 1143658|Chris|Bell|Strutt & Parker|13 Hill St 1143659|Chris|Bell|Strutt &...

hi AMACycle Thanks for your reply but this doesnt help. the property you have stated doiesnt exist!