Search results for query: *

I have been looking for a way to display details of my data source in my report on the report. I figured it would involve placing some code into the report code section, but my every attempt to do this has failed. It would be nice to be able to display any aspect of the report as the report...

Does anyone know why Windows 7 Professional 32-bit would hang during an automatic update? I have... - Disabled Anti-virus - Disabled the Firewall The Windows Update says it is "Preparing to Install", but has been stuck there with the progress indicator cycling for over 3 hours. Any ideas...

We have a machine running Excel 2010 on a Windows 7 Professional 64-bit Intel i7 Processor running about 3GB of RAM. When my user opens a local native version of .xlsx document it takes over 30seconds to load and when doing some of the most basic alterations to the spreadsheet, the changes...

Hello, I have been wrestling with pg_dump. PG_DUMP ISSUE #1 Has anyone got -T option to work on 8.x of PostgreSQL? I can't get this to work. -T option is supposed to exclude any specified table from your pg_dump output. Example script... pg_dump mydatabase -n myschema -T mytable1 -U...

I am expanding our in-house application on our Postgres database. One really key feature in Postgres is the ability to create Updatable Views. Unfortunately, I am not having much success when linking my Access 97 front-end to my view. The form in my Access app displays the records in the...

Hello, I am attempting to automate filling in fields in a Word 2003 Document from C#. I try to follow examples I have researched, but I am getting the following error at runtime, even though the project compiles without error.... "Unable to cast COM object of type 'System.__ComObject' to...

How would one construct PL code to call a function within a function dynamically? I already have a method for doing this, but in my opinion, there has got to be a better way. Example... CREATE OR REPLACE FUNCTION public.myfunction(schemaname text) RETURNS int4 AS $$ DECLARE myrec...

I needed function to check if a string was a valid date and noticed that there weren't any posts after searching a bit. Here is a quick and dirty function to check for this.... CREATE OR REPLACE FUNCTION isdate(mydate text) RETURNS boolean AS $$ DECLARE a date; BEGIN if mydate is...

Just wondering if anyone knew how to obtain the schema name of a currently running function. For example… CREATE OR REPLACE FUNCTION test.myfunction() RETURNS text AS $$ BEGIN return function_schema(); END $$ LANGUAGE ‘plpgsql’; I realize there is “current_schema()” function, but...

Everyone, Recently, I had to research a problem I was having switching my ODBC connection from an v8.0 Postgres database to v8.1. Below is a list of psqlODBC drivers, versions, dates, and results of my research. ------------------------------------------------------ PostgreSQL Win32Clients...

Just want to warn anyone considering buying a Maxtor External USB Drive, be careful! I strongly recommend avoiding the purchase of maxtor drives where they are externally based with a USB connection. From my personal experience I have had 2 out of 3 of these drives lose their partition...

Does anyone have experience using this feature? When I try to run the CREATE GLOBAL TABLE clause, the SQL parser rejects this as invalid syntax. But, the Postgres documentation has it in there as valid. I tried researching this, but I am not finding anything that seems to help. Btw...

After reading several recent posts today, I am pleasantly surprised that I am not the only one converting their MS Access applications to a PostgreSQL backend. It is definitely a great, stable, low cost solution to take and breath more life into an Access application until a better front-end...

While learning and translating VBA functions to PLpgSQL (PL), I have run up against a problem that needs a solution rather quickly. I am concerned that PL may have a limitation that could prevent me from standardizing a particular function. Here it goes... I need to be able to work with an...

Does anyone know how to exclude the sender from a distribution list? For Example.... John sends an e-mail to the Exchange E-mail Distribution Alias called, "Supersoft North America All", but John, also in that same list, receives the e-mail back to him. Is there a hack or a way to make...

After installing and accepting the defaults for Apache 2.0 and PHP 5.0 on my Windows 2000 Server, PHP does not seem to function at all. I followed the instructions in the readme for configuring Apache 2.0 with PHP, but I get a blank page when I run the phpinfo() function. I think the install...

After installing and accepting the defaults for Apache 2.0 and PHP 5.0 on my Windows 2000 Server, PHP does not seem to function at all. I followed the instructions in the readme for configuring Apache 2.0 with PHP, but I get a blank page when I run the phpinfo() function. I think the install...

The following occured during the installation of Beta-5 on Windows 2003 Standard Server. After clicking 'Finish' and files copying... "Failed to connect to the database. Procedural languages files are installed, but are not activated in any databases" <ok> "server closed the connection...

Does Merlin Legend or Magix support a system to allow callers to make payments by phone? If so, what do I need to set this up? Gary gwinn7

Using ADO.NET, how do you save data from a DataTable extracted from a different source and save it to your database? I have read and made several attempts, but have failed. Has anyone made this happen? If so, how did you do it? Sample code? Gary gwinn7