Search results for query: *

Hi all. The replace funcion changes a substring in my string to another I chose. What I need is to replace substring "A" for "B" and replace substring "B" for "A" at the same time. Obviously, I can make 3 replaces to do that but, anyone knows a function to do that at once ? Please help Me Dv

Hi ! I need to develop a tool which detects when a message is delivered or opened on outlook / express and asks to the user if he wants to save the content in a database. What ios the besst way to do it ? I thought about opening the outlook as an ole object and extract the info when it...

Hi. That was my solution: with queries on data analyzer you can do everything you want for this kind of field. Here an example: using a database called Legislacao, I can modify the field Texto from the table tbl_txt: EXEC sp_dboption 'Legislacao', 'select into/bulkcopy', 'true' GO DECLARE...

Yes. First of all: yes I have the full text indexing populated. Conceptually, My problem is: I need to search for those 2 words and they can be in any of the 3 tables. Those tables are related and are the same record, for instance. When I look for maciços, this word is on one of the tables...

Hi all I got a problem using contains on several tables. My statement has the following format: WHERE (Contains()) AND (Contains()) The first contains matches 2 results The second matches 78, in whis are included the 2 first. Logically the AND would find these 2 results, but doesn't find any...

No. There is no error. My problem is when the MS Project opens, try to use the database in sql and shows a window asking for a confirmation (in the window we can see the connection string used by the dsn). Its just a confirmation. What I really want is the project opening a SQL database without...

Hi all, I've got a problem. If somebody has the answer please reply my issue. I'm programming a software in VB which opens a Microsoft Project file. This file is connected to a SQL Database using a dsn. My problem is: When my software opens the microsoft project with a file, it prompts always...

Hi all. I'm having some problems importing a database from Oracle 8i to SQL Server 2000. All data is imported nicely except number. Even float numbers are ok, but when DTS imports a number field, its imported with the 0 value in cells. Anyone knows something in this issue to help me ? Dv

Thanks ! It works... The modem needs to make a reset... Dv

Hi Skrogzilla ! Thansk for answering me ! My problem is I need to use the ethernet card to connecto to other computer. That's why I want to let it free from the cable modem and use the USB connection to connect to internet. My intention isn't being switching from one to other, but actually I...

Hi all. I have an internet connection, through a ethernet card connected to a cable modem. It works nice. When I try to use the usb port to the modem there is no way to register my computer on the ISP Server. The Repair never works. I noted that all configuration of my 2 network connections...

The problem is: my csp page only defines the report on the link to access it, using the ID created on the Crystal Enterprise. This is the example: <a...

Hi ! Thanks for responding. Yes I'm using CSP page to export to pdf on the fly. On the past I had a problem using this method with a lot of parameters: at this time I lost my session variables and I needed to put less parameters. Now that is another report I was using on crystal ActiveX and I...

Hi all I'm publishing a report directly to pdf. I pass the parameters to the report and there is a filter on it based on those parameters. The first time access the report passing a parameter it igores it and makes a complete list without any filter. If I repeat the process (ie, access again...

Hi ! This issue was very helpful for me. Just a remark: using substring in sql, the 3rd entry is not the last charactere, but the length of the substring, so use: substring(memofield,1,255) as field1 substring(memofield,256,255) as field2 and so on... Dv

Great scc If you have any problem posting you r reports through ASP, tell us... Dv

I'll try and let you know the results Thanks Dv

I have the same problem. If anyone knows how to do it, please tell me Dv

Well. I know I only can introduce 1024 characteres because I introduced them manually and the SQL Manager doesn't allow me to insert more. Now I have my field with Text and 256 Bytes (using the text in row). I still only can insert 1024 characteres manually but my problem is: What are the...

Hi all. I need to put large text in a database field. When I try to use text data type or even varchar data type, the database only allow me to insertt 1024 characteres, even if I write the text directly on the database manager. My problem is: Microsoft says I can store large text (up to 2...