Search results for query: *

I am trying to pass a group of parameters when starting a new thread. eg: - Calling Procedure: - !Start thread, passing 1 parm SaveThread2 = START(NewProc2,35000,Loc:GroupName) Procedure Being Called: (NewProc2) - Prototype: (Group) Parameter: (MyGroup) How do I specify the group in...

Before I go down the a long path of writing a script for 250 tables, has anyone got a better idea. I am using MS SQL 2000 and I need to import incremental data changes from a unix system. There are 250 tables on the unix system. When a record in the unix table is inserted/changed a line is...

I am trying to setup a PIX at home so I can use remote desktop over VPN to access my machine from work. I am a newbie to the PIX but have managed to get a internet connection working, and the vpn connects. After the vpn connects I cannot ping the pix or my xp pc and cannot get the remote...

I am having great difficulty getting a web server working with my router. The web server is connected directly into the cisco and has a private ip address of 192.168.1.3 the router ip address is 192.168.1.5 The web server gateway is also 192.168.1.5 Can someone have a look at my script and...

Hello, I have no idea if this is the correct section to post this but here goes. I have a problem with a web server. Being a programmer and not a networking person, I am having difficulty solving the problem so please bare with me. I have a 8 port VPN firewall router. Plugged in the router is...

Hi, I have recently started to learn c# in my spare time. I am trying to create a simple database application with help from a step by step book. Can someone with experience point me in the right direction please. I have a form for entering a new customer. When the user presses the save...

I am having great difficulty trying to do a update without using a cursor. I want to update Table B reducing its qty(s) by the qty in Table A. I am also not allowed to modify the qty in Table A. I don't see a way of doing it because it needs to effect multiple rows. It's quite easy to do...

Has anyone managed to call a SQL function from clarion? I am able to call a stored procedure and pass parameters back as per the help. I do this by binding a data field and using &myVar [out]. There is nothing in the help with regards to functions. Has anyone got any ideas? Thanks, Chris

Can someone advise me on the best method to use to code my stored procedure without using a cursor? I have the following tables: - Order header, Order lines, receipts and allocations. One Order header to many order lines One Order line to many receipts I want to insert a row in the...

Not sure this is the correct place to be asking this but here goes. Our DBA who is also project leader designed our project (Warehouse dist. package) so that each company has its own database. At the application level the user has a menu option to change to another company. All companies...

Hi all, Appologies if this is not the correct section. Ive searched around everywhere and pulled out what hair I have left. Basically we have re-installed our windows 2003 small business server, everything is fine except that the workstations cannot access the samba shares. When I type in...

Hi all, Appologies if this is not the correct section. Ive searched around everywhere and pulled out what hair I have left. Basically we have re-installed our windows 2003 small business server, everything is fine except that the workstations cannot access the samba shares. When I type in...

I have created a stored procedure that removes an order line and updates balances and totals on related tables. I now want to create a stored procedure that removes an entire order. I was thinking of calling the stored procedure that removes the line for each line in the order. Select * from...

I am using crystal ver 8.5. I have a lot of reports that work from order files and I want almost identical reports to work from historical order files. The question is. Has Crystal XI got the ability to change a field on the report? Currently I am having to add the historical equivalent field...

Not being a SQL expert i'm having great difficulty with trigger. I am trying to update the total_value on the orderhdr table when a row or multiple rows is deleted from the orderline table. I have included the tables, triggers and my delete statement below. Please help its driving me mad...

Hi all, I am writing a report and I dont know how to produce the grand totals in the report footer for the following data. The file contains three columns: Reference, Type and Value. Ref Type Value --- ---- ----- 1 A 100 2 A 20 3 B 50 4 H 200 5 H 100 6 Z 800 The...

Hello all, I am a newbie to Crystal reporting so please bear with me. I want to incorporate the following SQL statement in my select expert so that the records are selected at the server. SELECT CustCode, CustName, AccBal, CreditLimit FROM CUSTOMER Where AccBal > CreditLimit The problem is...

Hi all, I have 3 files:- Customer, Items and History. I want to group by customer and show all items followed by all historical items as follows:- Customer: Fred Bloggs Item No.: 1001 1002 Hist No. 5001 5002 Each file has a customer code but using visual...