Search results for query: *

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...

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...

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...

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 =...

I keep getting an error: Function arguemnt value,type,or value is invlaid. This program is developed in FoxPro5, now the program runs fine when i run it in foxpro but when i attatch it to another program that calls it,...I get that error, that doesnt make sence to me. I'm a C#.net programmer so...

i think this is easy but it doesnt seem to work... update artran set disc2 = '0' where disc2 = null how do i enter the null value, 'null', '', nothing seems to work, thanks for the help. Software Engineer Team Lead damn bill gates, he has everything

I'm trying to create a trigger that when a record is deleted in one table the same record will be deleted from another table. The tables are exactly the same, just in different databases. I keep getting an error saying i'm not declaring @dcustno? Thanks in advance. create trigger...

I keep getting bad syntax next to the @Bdate and @edate, I doint see where the there is a syntax proble. For reference the pkpro..artran and pro30..artran are tables from different databases. Thanks in advance. CREATE PROCEDURE spArtran @bdate as smalldatetime(4) @edate as smalldatetime(4)...

I'm not sure how to do this exactly but this what i have so far: Select event,max(date) from tctest where event=@newEvent and userid=@contentUserid What i am trying to do, is retrieve the event from the most recent date for a certain user....if someone could just steer me int he right direction...

this is my code: select sum(lonhand) from iciloc where loctid = stock,zbond and item=@item @item is a parameter i passed. I'm not sure about the syntax but there is a table with where item come up twice. one for loctid=stock and one for loctid=bond. I'm trying to add the two together. Cant...

OK, got a problem. i'm calling a stored procedure from an ASP page, i call the procedure more than once. The first time it works perfectly, the second time it come back with an error saying it cannot find it. It is in the right place and all the code is correct, any reason for this occurence...

OK this is what I got, i have a stored procedure that updates a foxpro database through a linked server. Here is the stored procedure: CREATE procedure PKUpdateF @custno as varchar(6), @password as varchar(6), @sql as varchar AS set @sql = 'UPDATE OPENQUERY(tester, ''select password from...

i keep getting the error: Server: Msg 206, Level 16, State 2, Line 1 Operand type clash: image is incompatible with char I dont have any images in either table so I dont understand why it is doing this. If anyone could possibly explain why this might be happening i would appreeciate it...

I cant seem to get the correct syntax for this procedure, I think it has to do with my quotes, i think i'm doing them right? Thanks in advance, appreciate it. CREATE PROCEDURE PKUpdateF @password as nvarchar(6), @custno as nvarchar(6), @sql as varchar(1024) AS set @sql = UPDATE...

OK, here we go again with these darn linked servers... I'm trying to copy data from foxpro table into a sql table using linked servers. I keep on getting error 7321: an error occurred while preparing a query for execution against OLE DB provider MSDASQL. This is the code i used. I cant find my...

OK, i've gotten a select and an insert to work but i cant seem to get the update function to work. I keep on getting an error. Error 7399: OLE DB provider 'MSDASQL' reported an error missing operand. Here is my coding: SET ANSI_WARNINGS ON GO SET ANSI_NULLS ON GO create procedure PKUpdate...

OK, so i've linked together a foxpro db and sql server. I can update the foxpro db from EM, and I even created a stored procedure for to update the foxpro table. My next step is to transfer data from the foxpro table to a sql table using either update or insert, but i have to use the openquery...

ok so i used the stored procedure sp_addlinkedserver, and it seemed to work just fine, except when i went to look at the tables there were none there. I pointed it to a file where a few foxpro dbf files are but it didnt seem to find them. Any suggestions? Thanks in advance... Software Engineer...

Alright, i've been trying to set up a new linked server, on SQL SERVER 2000. I want to update foxpro tables. Some are the same machine as the SQL server and the others are on another machine. I'm a little lost on what i need to enter for the variables for the sp_addlinkedserver. I know @server...