How to use crystal report in VFP 8 ?

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Exchange Fox
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - sorting character field Dear All, I have this, which custID is a character field. custID customer ---------------------- 1000 ABC 2000 DBF 10000 EFG I would like to sort in sequence 1000 -> 2000 -> 10000 I have this sql statement, select custID ... order by custID it gives out the result -> 1000 -> 10003 -> 2000. What I think is covert the custID into a type integer before a sort is do (not good method). I would like to know if any better method. Many thanks. Regards, Wandy Tang Tag: How to use crystal report in VFP 8 ? Tag: 189359
  - 2
    - Write up a search function in text field! Hi All I have a simple question Once I have two fields from the same database file (say: customer.dbf) listed in list combo, how to use text field (type in the data from Customer.dbf and auto search) to search the record in the list combo And, if I double click the record in list combo, the data will automatally listed in other text fields of forms Thanks Sam. Tag: How to use crystal report in VFP 8 ? Tag: 189354
  - 3
    - datetime input mask I have a variable which is in long date format. How could I create a textbox that input the date part only (that is without the time portion)? `set date to short` doesn't work. -- .~. Might, Courage, Vision. In Linux We Trust. / v \ http://www.linux-sxs.org /( _ )\ Linux 2.4.22-xfs ^ ^ 11:50am up 13 days, 12:22, 0 users, load average: 1.00, 1.00, 0.92 Tag: How to use crystal report in VFP 8 ? Tag: 189352
  - 4
    - Driving a website using VFP Is there any way to programmatically drive a website using VFP? I want to log onto the site (username and password from FVP data) and then take specific actions within that site using VFP controlled logic and data. For example, I want to be able to initiate a file download from a site and store the data without any user intervention. If someone knows how to do this and has successfully done it, please let me know what you did. Thanks in advance Tag: How to use crystal report in VFP 8 ? Tag: 189351
  - 5
    - TURN $12 INTO $12,000 NOW!!! EEP THIS SHIT YALL MY FRIEND GOT $500 LAST WEEK TRYING THIS SHIT: make extra cash GREAT WAY TO BECOME RICH...INSTANT THOUSANDS This is no scam, read it!!!!!! ------------------------------------------------------------------------ -------- HOW TO TURN $12 INTO $12,000!!!!!!!!!!!!!!!!!!!!!!!!!!!! THIS REALLY CAN MAKE YOU EASY MONEY!! IT WORKS !!! BUT YOU HAVE TO FOLLOW IT TO THE LETTER FOR IT TO WORK!!!! : A little while back, I was browsing through newsgroup, just like you are now and came across an article similar to this that said you could make thousands dollars within weeks with only an initial investment of $12.00! So I thought, "Yeah, right, this must be a scam", but like most of us, I was curious, so I kept reading. : Anyway, it said that you send $2.00 to each of the 6 names and address stated in the article. You then place your own name and address in the bottom of the list at #6, and post the article in at least 200 newsgroup. (There are thousands) No catch, that was it. So after thinking it over, and talking to few people first, I thought about trying it. I figured what have I got to lose except 6 stamps and $12.00, right? Like most of us I was a little skeptical and a little worried about the legal aspects of it : All, So I checked it out with the U.S. Post Office (1-800-725-2161) and they confirmed that it is indeed legal! Then I invested the measly $12.00. Well GUESS WHAT!!?. Within 7 days, I started getting money in the mail! I was shocked! I figured it would end soon, but the money just kept coming in. In my first week, I made about $25.00. By the end second week I had made a total over $1,000.00! In the third week I had over $10,000.00 and it's still growing. This is now my fourth week and I have made a total of just over $42,000.00 and it's still coming in rapidly. Its : Certainly worth $12.00, and 6 stamps, I have spent more than that on the lottery!! : Let me tell you how this works and most importantly, why it works?.also, make sure you print a copy of this article NOW, so you can get the information off of it as you need it. STEP 1: Get 6 separate pieces of paper and write the following on each piece of paper "PLEASE PUT ME ON YOUR MAILING LIST." Now get 2 US $1.00 bills and place TWO inside EACH of the 6 pieces of paper so the bills will not be seen through the envelope to prevent thievery. Next, place one paper in each stating the above phrase, your name and address, and 2 $1.00 bills. What you are doing is creating a service by this. THIS IS ABSOLUTELY LEGAL! Mail the 6 envelopes to the following addresses: #1) Corteney Tomson P.O. Box 55 Dupo, IL 62239 #2) Brad Taylor 6 Terry Ln. Hutchinson, KS 67501 #3) Cedric Etienne 239 Autumn Breeze Way Winter Park, FL 32792 #4) Stephen Mitchell 1977 Alcovy Trace Way Lawrenceville, GA 30045 #5) Melissa Martinez 15440 sw 74 cir ct #607 Miami, FL 33193 #6) Maurice Sawyers 49 Middle Rose St Trenton, NJ 08618 STEP 2: Now take the #1 name off the list that you see above, move the other names up (6 becomes 5, 5 becomes 4, etc?.) and add YOUR Name as number 6 on the list. STEP 3: Change anything you need to, but try to keep this article as close to original as possible. Now, post your amended article to at least 200 newsgroups, message board. (I think there are close to 24,000 groups) All you need is 200, but remember, the more you post, the more money you make!---- DIRECTIONS----HOW TO POST TO NEWSGROUPS, MESSAGE BOARD----------Step 1) You do not need to re-type this entire letter to do your own posting. Simply put your cursor at the beginning of this letter and drag your : Cursor to the bottom of this document, and select 'copy' from the edit menu. This will copy the entire letter into the computer memory. Step 2) Open a blank 'notepad' file and place your cursor at the top of the blank page. From the 'edit' menu select 'paste'. This will paste a copy of the letter into notepad so that you can add your name to the list. Step 3) save your new notepad file as a .txt file. If you want to do your postings in different sittings, you'll always have this file to go back to. : Step 4) Use Netscape or Internet explorer and try searching for various newsgroups (on-line forums, message boards, chat sites, discussions.) Just example you log on any search engine like yahoo. com,google. com,altavista. com,excite. com then you search with this subject ? millionaire message board? or ?money making message board? or ? employment message board? or ?money making discussions? or ?money making forum? or ?business message board? etc. You will find thousand & thousand message board. Click one by one then you will find the option post a new message. : Step 5) Visit these message boards and post this article as a new message by highlighting the text of this letter and selecting paste from the edit menu. Fill in the Subject, this will be the header that everyone sees as they scroll through the list of postings in a particular group, click the post message button. You're done with your first one!. : Congratulations? THAT'S IT! All you have to do is jump to different newsgroups and post away, after you get the hang of it, and it will take about 30 seconds for each newsgroup! ** REMEMBER, THE MORE NEWSGROUPS OR MESSAGE BOARD YOU POST IN, THE MORE MONEY YOU EILL MAKE!! BUT YOU HAVE TO POST A MINIMUM OF 200** That's it! You will begin receiving money from around the world within days! You may eventually can rent a P.O. Box due to the large amount of mail you will receive. If you wish to stay anonymous, you can invent a name to use, as long as the postman will deliver it. **JUST MAKE SURE ALL THE ADDRESSES ARE CORRECT. ** : Now the WHY part: Out of 200 postings, say I receive only 5 replies (a very low example). So then I Made $5.00 with my name at #6 on the letter. Now, each of the 5 persons who just sent me $2.00 make the MINIMUM 200 postings, each with my name at #5 and only 5 persons respond to each of the original 5, that is another $25.00 for me, now those 25 each make 200 MINIMUM posts with my name at #4 and only 5 replies each, I will bring in an additional :$125.00! Now, those 125 persons turn around and post the MINIMUM 200 with my name at #3 and only receive 5 replies each, I will make an additional $625.00! OK, now here is the fun part, each of those 625 persons post a MINIMUM 200 letters with my name at #2 and they only receive 5 replies, that just made me $3,125.00!!! Those 3,125 persons will all deliver this message to 200 newsgroups with my name at #1 and if still 5 persons per 200 newsgroups react I will receive $15,625.00! With an original investment of only $12.00! AMAZING! When your name is no longer on the list, you just take latest posting in the newsgroups, and send out another $12.00 to names on the list, putting your name at number 6 again. And start posting again. The thing to remember is, do you realize that thousands of people all over the world are joining the internet and reading these articles everyday, JUST LIKE YOU are now!! So can you afford $12.. and see if it really works?? I think so? People have said, 'what if the plan is played out and no one sends you: the money? So what are the chances of that happening when there are tons of new honest users and new honest people who are joining the internet and newsgroups everyday and are willing to give it a try? Estimates are at 20,000 to 50,000 new users, every day, with thousands of those joining the actual Internet. AND YES YOU HAVE TO SEND THE MONEY FOR THIS TO WORK!!!dont try not to,IT WONT WORK TRUST ME Tag: How to use crystal report in VFP 8 ? Tag: 189349
  - 6
    - How to pass array by reference to VB dll from VFP8.0 I am passing arrays by reference parameters to Visual Basic dll from VFP8.0 and I am getting the following error Error 2020 The class file associated with this field cannot be found - class association cleared I believed this was fixed in VFP8 service pack 1. It is a known issue, but still it does not work. The same code works fine in VFP7.0, and now we are moving our app from 7.0 to 8.0. Any suggestion or workaround to this, please help Thanks Hitesh Pate Tag: How to use crystal report in VFP 8 ? Tag: 189336
  - 7
    - Change process priority I have a VFP 8 EXE and I want the EXE to run with a lower process/thread priority automatically. How do I change the EXE process priority from within the running EXE? M. Tag: How to use crystal report in VFP 8 ? Tag: 189335
  - 8
    - Regsvr32 (Kernel32.dll) I have read some of this elsewhere on forums in VB. Has anyone seen code that I can declare in VFP to call regsvr32 without having to shell out to register a dll Presently my line of code reads RUN REGSVR32 HASHCTL.DLL / where the switch bypasses a message box helping with security but still shelling out of the present environment. This works smashing otherwise Thanks in advance Charlane Tag: How to use crystal report in VFP 8 ? Tag: 189331
  - 9
    - Treeview Imagelist Assignment ProblemOLE Dispatch Exception Code 0 Hello: I am working in VFP8, SP1, and trying to add an imagelist OLE object to a form that also has a treeview control on it. When I try to assign the imagelist object to the treeview object, I get the following error message at runtime: OLE IDISPATCH EXCEPTION CODE 0 FROM TREECTL: INVALID OBJECT. The code I'm running, in the INIT method of the treeview control (tvProcessResults.init) is: This.ImageList = ThisForm.oleControl1 I have set up the imagelist OLE object with several 32x32 icon images in the ImageListCtrl Properties menu, and made sure that the INIT on the imagelist control runs *before* the INIT on the treeview. I can't figure out what is wrong here Ideas? Thanks! Steven C Tag: How to use crystal report in VFP 8 ? Tag: 189330
  - 10
    - VFP7 and VSS - Linked File problems Our dept. manager moved our repository to a newer, faster server (finally!). We have three projects which share a couple of files, and everything seems to be setup properly in VSS. However when we join two of the three projects through VFP all three of the shared files are not copied down to the client - but are still listed in the project. If I go into VSS and do a get on them they do appear in the project manager - but are not shown as being part of Souce Control (no lock icon, just a blank space). No matter what we have tried VFP won't realize those joined files ARE part of the repository. I have updated to the latest client. Unfortunetly the old server has been reformatted so there is nothing to go back to. Nothing has changed on the client machines during the transition from one server to the other - yet the problem has been tossed into the hands of the developers to solve. There is no problem checking out files through the VSS interface, except the text files are not created so we lose the ability to do text-compares between revisions. Losing that audit trail has been declared 'unacceptable' by the dept. manager. Any ideas and thoughts would be greatly apprecaited. Tag: How to use crystal report in VFP 8 ? Tag: 189329
  - 11
    - CursorFill() as a workaround to Requery() when inside a transaction. This is cool. I have validation code in a stored procedure that wants to REQUERY() a view when I issue a TABLEUPDATE() on a particular table. This is a problem because all of our generic "save changes" code includes wrapping TABLEUPDATE()s in a transaction when more than one table is going to be updated (and Requery() either error's out during a transaction or does nothing at all (depending on what's being requery'd). Changing the view into a cursoradapter allows "requerying" the cursor via the cursoradapter CursorFill() method. -- William Fields MCSD - Microsoft Visual FoxPro MCP - Win2k Pro US Bankruptcy Court Phoenix, AZ "Reality is merely an illusion, albeit a very persistent one." - Albert Einstein Tag: How to use crystal report in VFP 8 ? Tag: 189328
  - 12
    - using view to delete records I have defined two views. create sql view t_theorder remote connect myconn ; as select * from orders ; where orderid=?m.orderid =dbsetprop("t_theorder","view","sendupdates",.t.) =dbsetprop("t_theorder","view","tables","orders") =dbsetprop("t_theorder.orderid","field","keyfield",.t.) create sql view t_theodetail remote connect myconn ; as select * from "order details" ; where orderid=?m.orderid =dbsetprop("t_theodetail","view","sendupdates",.t.) =dbsetprop("t_theodetail","view","tables","order details") =dbsetprop("t_theodetail.orderid","field","keyfield",.t.) =dbsetprop("t_theodetail.productid","field","keyfield",.t.) I then use the following commands to delete the records: m.orderid=t_orders.orderid select 0 use t_theodetail shared =cursorsetprop("buffering",5,"t_theodetail") delete all if tableupdate(.t.) select 0 use t_theorder shared =cursorsetprop("buffering",5,"t_theorder") delete if !tableupdate(.t.) a_error[1]=.f. =aerror(a_error) =tablerevert(.t.) =messagebox("Error deleting header. "+a_error[2],48) endif else a_error[1]=.f. =aerror(a_error) =tablerevert(.t.) =messagebox("Error deleting detail. "+a_error[2],48) endif if used("t_theorder") use in t_theorder endif if used("t_theodetail") use in t_theodetail endif Then I hit an eror "No Update Tables specified. Use the Tables property of the cursor". I had no idea what I did wrong. -- .~. Might, Courage, Vision. In Linux We Trust. / v \ http://www.linux-sxs.org /( _ )\ Linux 2.4.22-xfs ^ ^ 11:08pm up 12 days, 23:40, 0 users, load average: 1.15, 1.07, 1.03 Tag: How to use crystal report in VFP 8 ? Tag: 189311
  - 13
    - keeping precision of number when converting to string If i have a number in a number field (nsalary) say 100.54 and want to convert it to a string to be exported to a text file that is being manually created, and i use str(nsalary) it returns "101" as the string... how do you get the number back as a unrounded number in a string with the same 2 digit precision? thanks! Tag: How to use crystal report in VFP 8 ? Tag: 189302
  - 14
    - EXE file behaves different than in Design Evnironment I am just starting with Visual Foxpro. I have been a long time CLIPPER developer and trying to switch to VFP to convert my applications from DOS environment to Windows plateform. I started off with a very simple application with one single form containing 4 variables, 4 labels, 4 text boxes and 2 buttons. I set ShowWindow property of the Form to "2 - AS TOP LEVEL FORM". I put the following code in Init and Activate methods of the form Init thisform.addproperty('ReadEventsFlg',.F. cInfile='KKKKKKKK cOutfile='LLLLLLLL dStart=ctod('01/01/2000' dEnd=date( Activate IF !THISFORM.READEVENTSFL READ EVENT THISFORM.READEVENTSFLG=.T ENDI In CONFIG.FPW, I put only one line SCREEN=OFF. The button named GO displays a messagebox showing values of the variables as entered by the user and CANCEL button has following code in CLICK_EVENT clear event thisform.releas When I run the form in Design environment, everything works fine i.e. the initial values of the variables are displayed as initialized in the Init method. However, when I compile an EXE and run it under runtime, it shows all blank values. I tried moving the initialization code of the variables from Init to Activate method. Then it shows the correct value for the first text box and as I click on other boxes, those values also show up correctly. I want the form to show all four values correctly as the form is first displayed. I have playing with it for 3 days now but with no success I would really appreciate help from the experts and make my entry into FOXPRO world a little easier Thanks in advance..... Tag: How to use crystal report in VFP 8 ? Tag: 189301
  - 15
    - thousands separator in numeric fields via ODBC Hello, when I select data>=1000 from foxpro numeric fields with decimal places I start receiving a comma as a thousands separator. I've looked through the ODBC help but I'm still not sure why this is happening, any ideas? I'd like to have no separator. -- TIA Andrew Howell Tag: How to use crystal report in VFP 8 ? Tag: 189300
  - 16
    - Check for numerical values How do I verify a string is a numerical value? Tag: How to use crystal report in VFP 8 ? Tag: 189298
  - 17
    - Beauty OOP report tool for VFP Dowload: English version: www.oopreport.com/ORT5_1033.rar Chinese(Traditional) version: www.oopreport.com/ORT5_1028.rar Chinese(Simplified) version: www.oopreport.com/ORT5_2052.rar More versions... For more pictures,please goto: http://myf1.net/bbs/dispbbs.asp?boardID=1&ID=238989 Tag: How to use crystal report in VFP 8 ? Tag: 189294
  - 18
    - VFP Toolbar - beyond a joke Whenever the VFP IDE reappears (ie starting VFP, finishing running an app, etc)("etc"?) the normal toolbar puts my docked project onto a separate line from the standard toolbar, and therefore doubles the height of the bar. I spoke about this before (a long time ago) and y'all said no-one else was seeing this. However I've now got the same effect on a different computer, still a laptop but that's about the only similarity, different operating system (XPH) and different hardware. This has to be a bug shirley? I have (only) the standard toolbar showing. There *is* space for the project to be docked onto the same line. What's going wrong? Grrrrr 8-( Mark Tag: How to use crystal report in VFP 8 ? Tag: 189292
  - 19
    - remote view and identity column of sql server orders ------------- orderid int, identity, primary key I used a view to open orders on sql server as t_orders. I then append blank a record in t_orders and tableupdate(.t.). How could I know the new value of orderid from sql server? If I issue requery("t_orders"), the record pointer would no longer on the newly appended record. I need the new value of orderid to build a new view with order_details. -- .~. Might, Courage, Vision. In Linux We Trust. / v \ http://www.linux-sxs.org /( _ )\ Linux 2.4.22-xfs ^ ^ 5:38pm up 12 days, 18:10, 0 users, load average: 0.99, 0.96, 0.91 Tag: How to use crystal report in VFP 8 ? Tag: 189288
  - 20
    - quick question on sql Dear All, I have forgot how to do this, counting the number of record for each customer appear in table sales. I make this, select customer, count() as total from sales group by alltrim(customer) The message keep popping up that the statement has missing expression. Please kindly help me out. Many thanks. Regards, Wandy Tang Tag: How to use crystal report in VFP 8 ? Tag: 189275
  - 21
    - odbc-configure connection dialog box always prompt, why ? Now, I can create my remote view programically (save as create_view.prg) However, everytime I run the create_view.prg, there is a dialog box prompt out , i need to press "OK" , otherwise, the remote cannot be created. It is very troublsome for the user . Can anyone how to solve it ?? Thanks in advance From agnes My code is shown as below. OPEN DATABASE u:\cgl\vfpseafreight\data\transport.dbc IF INDBC("t_data","connection") = .F. CREATE CONNECTION t_data; connstring ; 'Driver={Microsoft Visual Foxpro Driver};DBQ=u:\cgl\vfpseafreight\data\transport.dbc;BackgroundFetch=Yes' ENDIF IF INDBC("tview","VIEW") = .F. CREATE sql VIEW tview remote CONNECTION t_data AS SELECT number,jobno,closesw FROM billLadingHeader order by number ENDIF Tag: How to use crystal report in VFP 8 ? Tag: 189274
  - 22
    - curdir fullpath When I use curdir() it does not give the full path, is there any way to do this??? Tag: How to use crystal report in VFP 8 ? Tag: 189262
  - 23
    - Return value I'm using createobject to reference a class object that consists of a form with a text box. If in the unload event of the class, I'm returning a value, how do I grab the value in the parent form? Tag: How to use crystal report in VFP 8 ? Tag: 189260
  - 24
    - Is ProFox there? Does anyone know if the ProFox list is running? I haven't heard from it for a while. -Lew Tag: How to use crystal report in VFP 8 ? Tag: 189257
  - 25
    - UNABLE TO ERASE A FILE I have the following situation. I create a text file from a table that meet a certain condition. I'm using the following command. COPY TO ( cOutput ) FOR STORE <> "CA" TYPE SDF IF no records meet the condition then FoxPro creates a file with zero bytes. The problem that I'm having is that I cannot delete this file until I'm completing out of FoxPro. Here's the error that I'm getting. There has been a sharing violation - The source or destination file may be in use. Does anyone know how I go about closing the file so that I can erase it in the program? Thanks Tag: How to use crystal report in VFP 8 ? Tag: 189256
- Next
  - 1
    - Interface of visual foxpro to C++ routines How can I call a C++ routine from vfoxpro? And How is to complie and linkedit the two modules: a main foxpro with a C++ sub I cannot visualize how join the two softwares. Tag: How to use crystal report in VFP 8 ? Tag: 189254
  - 2
    - Help!!! how do I get an Icon file. I need ico for imagelist. I neet to get 3 icons (word,excel,pdf) as imagefiles so that I can load them in the imagelist for my tree. How can I get to these Icons. I went to word for example and I couldn't fine the icon file. thanks Nick Patel Tag: How to use crystal report in VFP 8 ? Tag: 189244
  - 3
    - combobox and bounding the view: t_jobs job_desc job_id ------------- ------ manager 4 clerk 5 n/a 3 I want the value of job_id (column 2) while the form will show job_desc (column 1). The combobox is set up as follows: controlsource=thisform.var rowsource=t_jobs rowsourcetype=1. alias boundto = .t. boundcolumn = 2 whenever I click the combobox to select a value, it always become blank. what step did I miss? -- .~. Might, Courage, Vision. In Linux We Trust. / v \ http://www.linux-sxs.org /( _ )\ Linux 2.4.22-xfs ^ ^ 12:26am up 12 days, 58 min, 0 users, load average: 1.00, 1.01, 1.00 Tag: How to use crystal report in VFP 8 ? Tag: 189242
  - 4
    - HOW TO CREATE ODBC CONNECTION PROGRAMMICALLY ?? create the connection and view programmically. However, there is an error. Please give me a hand OPEN DATABASE d:\data\account.dbc SET DATABASE TO "account" IF INDBC("acct1","CONNECTION") = .F. Create connection acct1 ; connstring; 'Driver={Microsoft Visual Foxpro Driver};DBQ=d:\data\account.dbc'; CREATE sql VIEW arinvtest REMOTE CONNECTION acct1 AS SELECT * FROM arinvheader endif Thanks in advance from agnes Tag: How to use crystal report in VFP 8 ? Tag: 189239
  - 5
    - calling button.click() from form.release()? I am using Visual Foxpro 6.0. When a user clicks the "X" button on a form, the form.release() method would be called. Is it possible to make it run the code in cancel_button.click() event first? I think it's a bad idea to call another event from within another event. Right now I disabled the "X" button. -- .~. Might, Courage, Vision. In Linux We Trust. / v \ http://www.linux-sxs.org /( _ )\ Linux 2.4.22-xfs ^ ^ 11:30pm up 12 days, 2 min, 0 users, load average: 1.00, 1.00, 1.00 Tag: How to use crystal report in VFP 8 ? Tag: 189236
  - 6
    - Populate combobox at runtime How do I populate a combobox at runtime with data from cursor? Tag: How to use crystal report in VFP 8 ? Tag: 189235
  - 7
    - russian, cyrilliic character font ?? with FoxPro 2.6 Hello, i am using FoxPro 2.6. i want to create a multi language table including different languages. Has somebody an idea, how i can store into a table the cyrillic charater font. And i also want to make a print out of the cyrillic text. is this possible in this old version of foxpro ??? thanks in advance for answers Wolfgang wolfgang@wolfgang-munich.de Tag: How to use crystal report in VFP 8 ? Tag: 189234
  - 8
    - Page printing selection in VFP report preview. How to select only some pages for printing in VFP report preview. Is is possible to print only current page while viewing the preview Thanks Tag: How to use crystal report in VFP 8 ? Tag: 189227
  - 9
    - wich field was updated ? I'm writing a trigger in a dbc (VFP6 SP5 + WXP). the same trigger is for update over 250 files, with each around 200 fields. On update, this trigger inserts a record in an other table. All works ok, but I need to store the names of the fields from where this trigger is run. I have alias, dbf, working areas ; if I have field name, I can use oldval and curval.. How can I retrieve field names ? Thank you in advance for help Michel (in France) Tag: How to use crystal report in VFP 8 ? Tag: 189223
  - 10
    - Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc I create the connection and view programmically. However, there is an error. Please give me a hand OPEN DATABASE d:\data\account.dbc SET DATABASE TO "account" IF INDBC("acct1","CONNECTION") = .F. Create connection acct1 ; connstring; 'Driver={Microsoft Visual Foxpro Driver};DBQ=d:\data\account.dbc'; CREATE sql VIEW arinvtest REMOTE CONNECTION acct1 AS SELECT * FROM arinvheader endif -- Thanks For Your kind Attention. Best Regards, Miss. Agnes Cheng Dynamic Tech Consultants Ltd. T:2264-5583 F:2264-5584 mail : agnes@dynamictech.com.hk Tag: How to use crystal report in VFP 8 ? Tag: 189222
  - 11
    - [ALT] key cannot open menu while running in EXE I have designed a menu 'MAINMENU' and define the ALT key in [keypress] in menu designer. This menu will be called from a form 'MAIN', The ALT key works while in the design time, after that, I compile it to build an exe file, the ALT key doesn't work. Inside the initial main.prg, I have several environment settings and at last, there is as do form MAIN read events and in the INIT event of form MAIN, the content is do mainmenu.mpr with thisform, .t. Below are some setting of the form MAIN ShowWindow - 2-As Top-Level Form WindowType - 0-Modeless MDI Form - .f. Please, can anyone give me a hand on this issue. thanks lot Edward Tag: How to use crystal report in VFP 8 ? Tag: 189215
  - 12
    - How : Create remote view programmically? I try the folllowing code to create the odbc connection and remote view. However, those code didn't work . Canyone give me a hand ? OPEN DATABASE u:\sample\data\tradelink SET DATABASE TO "tradelink" IF INDBC("itts_connection","CONNECTION") = .F. Create connection itts_connection ; connstring; 'Driver={Microsoft Visual FoxPro Driver};'+; 'DBQ="u:\sample\data\tradelink" ;' CREATE VIEW itts_chl CONNECTION itts_connection AS SELECT * FROM CHL -- Thanks For Your kind Attention. From Agnes Tag: How to use crystal report in VFP 8 ? Tag: 189208
  - 13
    - Promatrix Spam! Just for those of you who don't take kindly to spam (I've never made any approach to Promatrix): Return-Path: <promatrixnews@promatrix.com> Delivered-To: astechsystems@iinet.net.au Received: from unknown (HELO ms-smtp-03.tampabay.rr.com) (65.32.5.133) by mail.iinet.net.au with SMTP; 2 Feb 2004 23:29:03 -0000 Received: from EMACH1 (653220hfc53.tampabay.rr.com [65.32.20.53]) by ms-smtp-03.tampabay.rr.com (8.12.10/8.12.7) with ESMTP id i12NSD1H027087 for <astechsystems@iinet.net.au>; Mon, 2 Feb 2004 18:28:58 -0500 (EST) Message-ID: <4149-22004212232748359@EMACH1> Organization: ProMatrix Corp. From: "ProMatrix" <promatrixnews@promatrix.com> To: astechsystems@iinet.net.au Subject: Professional Visual FoxPro Framework Only $49.95! Date: Mon, 2 Feb 2004 18:27:48 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_84815C5ABAF209EF376268C8" X-Virus-Scanned: Symantec AntiVirus Scan Engine X-Spam-Status: No, hits=3.6 required=5.0 tests=EXCUSE_3,FOR_JUST_SOME_AMT,HTML_40_50,HTML_FONT_BIG, HTML_FONT_COLOR_BLUE,HTML_SHOUTING3, HTML_TABLE_THICK_BORDER,MAILTO_TO_REMOVE, MIME_BOUND_NEXTPART,RCVD_IN_RFCI version=2.55 X-Spam-Level: *** X-Spam-Checker-Version: SpamAssassin 2.55 (1.174.2.19-2003-05-19-exp) ------=_NextPart_84815C5ABAF209EF376268C8 Content-type: text/plain; charset=US-ASCII VPM Standard Only $49.95. Go to: http://www.promatrix.com/mall/vpms01.asp VPM Enterprise 8.1 Now With Multilingual Toolkit and Source Control. Go to: http://www.promatrix.com/vpme/vpme01.htm ------=_NextPart_84815C5ABAF209EF376268C8 Content-Type: text/html; charset=US-ASCII <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <title>Spotlight on  VPM 7</title> </head> <body topmargin="0" leftmargin="0" bgcolor="#FFFFFF"> <div align="center"> <center> <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%"> <tr> <td width="100%" align="center"> <table border="1" width="615" style="border-collapse: collapse" bordercolor="#000080" cellpadding="0" cellspacing="0" bgcolor="#000080"> <tr> <td width="26%" bgcolor="#000080"> <img border="0" src="http://promatrix.com/email/pweb_banner_navy.gif" width="195" height="60"></td> <td width="74%" bgcolor="#000080"> <p align="center"><b><i><font face="Arial" size="7" color="#FFFFFF"> Breaking News</font></i></b></td> </tr> </table> <table border="0" width="615" bgcolor="#000080" cellspacing="0" cellpadding="0" style="border-collapse: collapse" bordercolor="#111111"> <tr> <td width="100%" bgcolor="#000080"> <hr> </td> </tr> </table> <table border="3" width="615" bgcolor="#FFFFFF" cellpadding="3" cellspacing="0" style="border-collapse: collapse" bordercolor="#000080"> <tr> <td> <table border="0" width="100%" cellspacing="3" cellpadding="2" style="border-collapse: collapse" bordercolor="#111111"> <tr> <td width="83%" align="center"> <b><font face="Arial" size="4" color="#000080">News Topics</font></b></td> </tr> <tr> <td width="83%" align="center"> <ul> <li> <b><font face="Arial" size="4" color="#0000FF"> <a href="#Get VPM Standard For Only $49.95">VPM Standard Only $49.95</a></font></b></li> <li> <b><font face="Arial" size="4" color="#0000FF"> <a href="#VPM Standard Multilingual Toolkit Now Only $49.95">VPM Standard Multilingual Toolkit Only $49.95</a></font></b></li> <li><b><font face="Arial" size="4" color="#0000FF"> <a href="#VPM Enterprise 8.1 - Multilingual & Source Control">Introducing VPM Enterprise 8.1</a></font></b></li> <li><b><font face="Arial" size="4" color="#0000FF"> <a href="#VPM Enterprise 8.1 Demo Now Available">VPM Enterprise 8.1 Demo Now Available</a></font></b></li> </ul> </td> </tr> </table> </td> </tr> <tr> <td height="29" bgcolor="#000080" bordercolor="#000080"> <p align="center"> <b> <font face="Arial" size="5" color="#FFFFFF"> <a name="Get VPM Standard For Only $49.95">Get VPM Standard For Only $49.95</a>!</font></b></td> </tr> <tr> <td height="29"> <table border="0" cellpadding="2" cellspacing="3" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber2"> <tr> <td width="100%"> <p align="center"><b><font face="Arial" color="#0000FF">A regards - anthony shipley look, ma - no .sig Tag: How to use crystal report in VFP 8 ? Tag: 189206
  - 14
    - My grid´s rightclick event is lost Hi all! I have to close and reopen a view to populate a grid (designed in VFP7) in VFP8. This probably because of lack of backcompatibility VFP8 to VFP7. I do this with the code below. SELECT vwRelscomp USE USE vwRelscomp IN 0 SELECT vwRelscomp Requery('vwRelsComp') This.Grid1.RecordSource = 'vwRelscomp' This.Grid1.Column1.Text1.ControlSource = 'vwRelsComp.relname' This.Grid1.Column1.Width = lnCol1Width && saved before closing the view Now the grid is populated again even in VFP8 but the Grid1.Column1's capacity to fire it's rightclick event becomes lost. How can I get the rightclick event (a shorcutmenu designed i the menubuilder) back to work? Regards Christina Tag: How to use crystal report in VFP 8 ? Tag: 189205
  - 15
    - VFP running Access Query/Macro Hi Do you know of a way to run an Access query/macro from within VFP. No ODBC Similar to usin loXL = getobject('','Excel.Application' loWB2 = loXL.Workbooks.open('c:\earnedvalue\module\earned_value_data_shell.xls' loWB2.Application.Run('earned_value_data_shell.xls!import_data' to run an Excel macro Thanks Ga Tag: How to use crystal report in VFP 8 ? Tag: 189203
  - 16
    - micration tool What is the best migration tool for VFP 6.0 ? -- George Malekkos ________ --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.572 / Virus Database: 362 - Release Date: 27/1/2004 -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 100,000 Newsgroups - 19 Different Servers! =----- Tag: How to use crystal report in VFP 8 ? Tag: 189191
  - 17
    - Printing statements to Adobe files I would like to print statements to individual adobe print files for emailing. I have developed a process that runs the statement report for each customer. When I change the printer to Adode it asks the name of the file. I would like to send the name of the file for Adobe to use so I don't have to type it in for each customer. I am not finding an approach to send the name to Adobde. Any ideas? Tag: How to use crystal report in VFP 8 ? Tag: 189189
  - 18
    - How Add a CommandButton on 1 Activex Dear All, I wants to add a CommandButton (Setup impression) on 1 Activex (CRviewer of CrystalREport). This AcTivex is on a Form. There is not method "Addobject" for this Activex. I use the addobject of Form but as you suspect it the button comes to be placed below the activex and is thus not visible. The method Zorder(X) does not arrange anything . It would be necessary to be able to say to the button "Always One Top"...... thank you in advance for the assistance brought. Bernhart Tag: How to use crystal report in VFP 8 ? Tag: 189183
  - 19
    - Hardware Control via Printer-port ? Hi All, I've bought an "On-Off" relay control board with source code written by "VB" and "C++", actually I don't know the above 2 languages, can someone tell me VFP can do the same thing ? Thanks ! Regards Sammy Tag: How to use crystal report in VFP 8 ? Tag: 189182
  - 20
    - Sending faxes using foxpro and windows 2003 sbs Dear All I am having problems with mapi sending faxes with Outlook 2000 sp3, xp and 2003. Early version are ok. I am getting to a point where I think it may be a security issue. Sending a normal fax is ok, but if I attach a *.tif file it comes up undeliverable with the message The Microsoft Fax transport failed to deliver the message to the recipient. Not all attachments can be rendered. Here is my code, I have changed the fax number. objSession = CreateObject("Mapi.Session") objSession.Logon () MESSAGEBOX("CDO version installed is "+trans(objSession.Version)) objMessage = objSession.Outbox.Messages.Add objMessage.Subject = "Test" objMessage.Text = "This is a test with an attachment" objRecipient = objMessage.Recipients.Add objRecipient.Name = "[FAX:5555555555]" objRecipient.Type = 1 objRecipient.Resolve () objAttachment = objMessage.Attachments.Add() objAttachment.Position = 0 objAttachment.Type = 1 objAttachment.ReadFromFile("C:\B.TIF") objAttachment.Source = "C:\B.TIF" objAttachment.Name = "B.TIF" objMessage.Send () objSession.Logoff Thank you for any help David Anagram Systems Limited work email: david@anagram-sys.co.uk Tag: How to use crystal report in VFP 8 ? Tag: 189181
  - 21
    - System Clock Hi Is it possible for VFP to hide the system clock so that no one ca change the time of the computer Thanks Abe Tag: How to use crystal report in VFP 8 ? Tag: 189179
  - 22
    - Incorrect page footer information problem env: O/S 2000 sp4 vfp7 sp1 on report designer, 1.data grouping is set, new page when group change 2.fields on group footer band is set "Stretch with overflow" If fields stretch with overflow on group footer and it overflow to next page, it affect the result of field on page footer on current group and next group. Steps to Reproduce: Create table by following code: create table table1 (f1 c(10),f2 m) insert into table1 (f1,f2) value ('A','') insert into table1 (f1,f2) value ('B',repl('X'+ chr (13),200)) && overflow to next page insert into table1 (f1,f2) value ('C','') create report testbug add data grouping expression "f1" : set "Reset page number to 1 for each group" add report variables "vf1" with Expression : f1 on page header band : add a field Expression : f1 on detail band : add a field Expression : f1 on "group footer : f1" band : add a field Expression : f2, set "Stretch with overflow". on page footer band : add a field Expression : f1 Save report do a command : report form testbug preview Or report form testbug to print result : Assume Group A is printed on page1, Group B is printed on page2 and 3 because for group footer overflow to next page, Group C is printed on page4 on page footer band when f1 group B : field "f1" display C && incorrent field "vf1" display B && corrent on page footer band when f1 group C : field "f1" display C && correct field "vf1" display B && incorrent Is it a bug? thanks. Ray Tag: How to use crystal report in VFP 8 ? Tag: 189178
  - 23
    - Foxpro 6 Tutorial Hi All, I am the very beginner of Foxpro. Currently, I have Foxpro 6.0 installed in my computer(windows ME 2000). I would be very appreciated if some one can tell me the websites which contain the Foxpro 6 Tutorial. Have a nice weekend! Best Regards Richard Tag: How to use crystal report in VFP 8 ? Tag: 189175
  - 24
    - Graphical editing of a class Hi all, If I define a class in a program (not is the class designer), how could I edit it in the class designer? Thanks Hutch Tag: How to use crystal report in VFP 8 ? Tag: 189173
  - 25
    - not insert to table Dear All, I have 2 tables, sales and salesdetail here is my source: sales set to buffering-3 salesdetail set to buffering-5 begin transaction insert into sales(...blah blah blah) insert into salesdetail(...blah blah blah) if (tableupdate(0, .f., "sales") and tableupdate(1, .f., "salesdetail")) end transaction strange thing is, I got salesdetail updated but sales always got nothing. no error message pop out. Can't figure what's wrong. Many thanks. Regards, Wandy Tang Tag: How to use crystal report in VFP 8 ? Tag: 189170

Hi,

If I make my report by using crystal report 7 what kind of crystals report files (DLL)
should I copied to my non crystal report PC's ?
I just make teks/standard report.

Thank's alot for your kind help and infomarmation...

Top

Re: How to use crystal report in VFP 8 ? by Eric

Eric
Thu Feb 05 03:16:16 CST 2004

Hello, anggi!
You wrote on Thu, 5 Feb 2004 00:41:04 -0800:

a> If I make my report by using crystal report 7 what kind of crystals
a> report files (DLL) should I copied to my non crystal report PC's ?
a> I just make teks/standard report.

Check this article.
KB014: Integrating Crystal Reports with Visual FoxPro
http://www.craigberntson.com/Articles/kb014.htm
--
Eric den Doop
www.foxite.com - The Home Of The Visual FoxPro Experts - Powered By VFP8

Top

Re: How to use crystal report in VFP 8 ? by Craig

Craig
Thu Feb 05 10:33:07 CST 2004

There is not a simple answer to this question as the files required depend
on what you are doing in your report and what type of data access you are
using. You should search the Crystal Reports knowledgebase at
http://support.businessobjects.com/search/default.asp

--
Craig Berntson
MCSD, Visual FoxPro MVP
Author, CrysDev: A Developer's Guide to Integrating Crystal Reports
www.craigberntson.com
email iamcraig@craigberntson.com (remove iam)
Salt Lake City Fox User Group
www.slcfox.org

"anggi" <anonymous@discussions.microsoft.com> wrote in message
news:B8A6CF45-BCC5-4CAF-A517-762CEB533081@microsoft.com...
> Hi,
>
> If I make my report by using crystal report 7 what kind of crystals report
files (DLL)
> should I copied to my non crystal report PC's ?
> I just make teks/standard report.
>
> Thank's alot for your kind help and infomarmation...
>

Top