Our users work on a central MS Terminal Server system. They open relative small PDF files on the TS. But printing such a file results in a huge data transfer over the WAN to the local printer.
Is it possible to prevent this?
We used to have Canon multi functional printers (with this problem)...
I have a table with 100.000.000 records, where 'only' 25.000.000 are needed. I don't want to delete those 75.000.000 records, i want them removed from my production environment database into an 'archive-database'. Every quarter or so i will move reocrds from production to archive. So i only need...
I created a simple ON Update trigger on MyTable.
When i open MyTable and change a field, the trigger works fine (basically it is make a copy of the altered row in another table).
But when i do an UPDATE MyTable SET ... the trigger is NOT working. In some situations that may be good behavior, but...
i give an Excel cell a custom format 0000.
After clicking OK, i do again "Format cell..."
Now it is set to "Special" Codigo Portugal!
Oke, the effect is the same, but it looks strange.
Is it possible to edit the special formats?
or better: disable them?
I'm trying to create MS Exchange appointment via a trigger.
The following ASP code is working A-oke:
strApptURL = "http://" & strExchSvrName & "/exchange/test/Calendar/testappointment.eml"
strApptRequest = "<?xml version=""1.0""?>" & _
"<g:propertyupdate " & strXMLNSInfo & _...
I'm trying to create MS Exchange appointment via a trigger.
The following ASP code is working A-oke:
strApptURL = "http://" & strExchSvrName & "/exchange/test/Calendar/testappointment.eml"
strApptRequest = "<?xml version=""1.0""?>" & _
"<g:propertyupdate " & strXMLNSInfo & _...
I want to fill a MS SQL Mobile (SDF) database with records from a DBF file.
So i hoped this is working:
oConnSDF=Createobject("ADODB.Connection")
oConnSDF.open("Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data Source=myfile.sdf;")
USE SOURCE
DO WHILE NOT EOF()
cSQL = "INSERT INTO...
I need to INSERT records in a MS SQL 2005 table with an uniqueidentifier field.Is it possible to create the full SQL statement in the VFP program?
Or should i write a SP in the database that accepts the values from my program and uses the NEWID() function?
Other ideas?
With MSSQL2K i started DTS jobs via a stored procedure. SP's i could start from ASP webpages, and all went very well.
The first clash with SQL 2005 was the move from DTS to SSIS. I have now DTSX structured files, and my current approach is to run these with a Job (Type=SSIS package, source file...
At the moment i have 3 SQL servers in HQ: MS Business Solutions Axapta, Business Objects and Intranet + supporting web-apps.
Later this year we will migrate our DOS (!) logistic system to something running on MS SQL. So we will install a SQL server on every plant/location (15).
There is no ICT...
I have a form with 5 different fields that require the user to enter a valid name-code. [The valid codes are stored in a SQL database (about 150)].
I do not want to build 5 <SELECT>'s with 5x150 <OPTION> lists.
Of course it is possible to enter 5 codes first, and do the validation after...
<select name=field>
<option value=1>Apple
<option value=2>Banana
<option value=3>Ananas
</select>
in a script i can use document.form.field.value in order to get the selected value (eg 1). But how can i get the selected DESCRIPTION (eg Apple). . .
After selecting a value i want another field...
My ASP program creates a random number of INPUT fields (i do not know the number in advance). The fields have a sequential name, like "F1", "F2", "F3", etc. After SUBMIT every field with a value must be processed.
So my program must check document.form.f1.value up...
After pressing F5 (Refresh) IE is presenting me the question 'The page cannot be refreshed without resending the information....' I have to press the Retry-button (or Enter) in order to get my refreshed page.
I always want to refresh. How can i bypass this question?
(I do not look for an...
After pressing F5 (Refresh) IE is presenting me the question 'The page cannot be refreshed without resending the information....' I have to press the Retry-button (or Enter) in order to get mu refresh. I always want to refresh. How can i bypass this question? (I do not look for an automatical...
In A.ASP i show the user a list of records from a MS-SQL7 database TY. The user may select 1 record for update. This is done in program B.ASP
TY has one primary key field: tycode. Examples of codes are: 1x, 2x, 2-, 2+, 4x, 4-, 4+, etc.
When a user clicks on a link like this:
<a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.