Recent content by oakpark5

I have a general question. We have decided to build a new customer relationship management/sales order entry program. We all agree on the problems and where we want to be.....but, we are debating what to develop in. We currently use Visual FoxPro 5,8 and will probably upgrade to 9. We recently...

OK, i got that to work, now I'm trying to carry a couple variables through, like the subject and the body. I dont quite know how to account for multiple rows.....here is that I'm using: CREATE PROCEDURE sp_remindertest AS declare @email as char(50) declare @custno as char(25) declare @task as...

Thanks everyone, it worked perfectly! Software Engineer Team Lead damn bill gates, he has everything

I have a stored procedure that executes a query, I want to pass the results to another stored procedure, not quite sure how to do that, i tried setting @results to the select query and the executing it, but when i put @results in for the email protion it returned the whole select statement. I...

got it, thanks!!! Software Engineer Team Lead damn bill gates, he has everything

I've got a sql string and what I'm trying to do is this: select * from table where invdte between current_date and current_date - 3 months. Basically I want everything thats between the date today and the date 3 months ago... just not sure how to get the three months ago part.... Software...

OH!, I remember doing something with that...so if i give it an alias and designate its IP, can I then set it as a linked server? Thanks you're a big help... Software Engineer Team Lead damn bill gates, he has everything

Got it working I needed to install the DTC windows component, and add the SET XACT_ABORT ON in the code of the trigger,but now I have to set up another linked server that is on a VLAN and I know names dont resolve through, but IP'S do. Just have to figure out the naming convention.... Software...

Well the linked server works if i dont use it in a trigger, bit I need a trigger to do this. Here is what is happening. We have cisco VOIP phones that insert information into a SQL database, i've put the trigger on that databse to fill a table on another database that runs more of our internal...

Server: Msg 7391, Level 16, State 1, Procedure trig_insertcalls, Line 7 The operation could not be performed because the OLE DB provider 'MSDASQL' was unable to begin a distributed transaction. [OLE/DB provider returned message: [Microsoft][ODBC SQL Server Driver]Distributed transaction error]...

Hopefully someone can help me with this.... I created a trigger to insert 4 records into a SQL server databse from another SQL server database. The two databases are linked by linked servers... CREATE trigger trig_insertcalls on dbo.testcalls for insert as print 'hi' insert into...

Having some problems linking two sql servers together, one is my local machine. I'm setting up the link to the main server to connect to mine, but it doesnt seem to want to work. This is what I've tried: use master go sp_addlinkedserver @server = 'ITDAVID', @srvproduct = ' ', @provider =...

Well thanks for the help everyone, I finished the program...and no offense but this was the first and most likely the last time I'm going to use FoxPro, I'll stick with C# and Java..... Software Engineer Team Lead damn bill gates, he has everything

Adding this to the first line seemed to fix the problem: or empty(lc_plinid) I'm not to happy with the speed of the programe either. I'm connecting to a SQL server, does foxpro5 support ADO and can it call sql stored procedures? Do you think this would help the speed of the program? Software...

OH, and why cant I call functions on a form? Annoying... Software Engineer Team Lead damn bill gates, he has everything