Hello,
I am querying some TPS files and trying to build a query using an isnull() function such as "Select isnull(fieldname, '') as myfield from unnamed"
also is there a listing of Topspeed functions that can be used?
thanks
G
George Oakes
CEO & President
COPS Software, Inc...
Use ODBC to communicate with the data
George Oakes
CEO & President
COPS Software, Inc.
www.cops2005.com
Programmer & Developer
.Net, WSS 3.0, SQL DBA
Check out this awsome .Net Resource! http://www.learnvisualstudio.net
Thanks CajunCenturion,
I had feeling that because it was an object the compiler was treating it differently than a string or other data type variable.
George Oakes
CEO & President
COPS Software, Inc.
www.cops2005.com
Programmer & Developer
.Net, WSS 3.0, SQL DBA
Check out this awsome .Net...
I am looking at the subroutine, and he is actually passing in the Odt object ByVal, not ByRef, so that wouldn't even work then would it?
George Oakes
CEO & President
COPS Software, Inc.
www.cops2005.com
Programmer & Developer
.Net, WSS 3.0, SQL DBA
Check out this awsome .Net Resource...
Hello all,
I am having to do a code review on one of our contractors and ran across an interesting piece of code.
The contractor created a datalayer and used sub routines instead of functions to return values. And my question is why would he do this and how does it differ from best practices...
I had thought of a table, but was hoping for a more Programatic way of doing this.
As for leap years, the DATEADD function does take that into account.
George Oakes
CEO & President
COPS Software, Inc.
www.cops2005.com
Programmer & Developer
.Net, WSS 3.0, SQL DBA
Check out this awsome...
All I need to display a group of records for the week. This group of records will be all records that are either 30, 60, 90 or 1yr old and each yr after. Because this is a weekly report I will be displaying records 30-37 days old, 60-67 days, 90-97 days and 365 to 372 days old and every year...
There are no other data components on the form simply the fields
that are layed out on the page.
All other formats display the data correctly.
with one exception, in Excel the first line is blank(where the headers might be, but there are no headers in the report) the rest of the formats are...
Well its not only sent out as a CSV, others use the data for spreadsheets, and reporting elsewhere, so an SSRS report makes sense here.
George Oakes
CEO & President
COPS Software, Inc.
www.cops2005.com
Programmer & Developer
.Net, WSS 3.0, SQL DBA
Check out this awsome .Net Resource...
I have an SSRS report, that returns data that we need to send to a main frame.
The main frame will accept a CSV file, so we created a subscription to email the report in CSV format to the main frame.
Problem is when the report runs, and the csv file is generated the first line of the report...
OK so this maybe a newbee question, so forgive me.
I have a sharepoint list. the user needs to be able to enter a Date 1/1/2010 and a time 12:12:12 am
I tried creating a date time column however the time shows up as a Hour, Minute widget and the minutes are in 5 minute increments. This wont...
I want to open an infopath form via URL with input parameters, when the form opens I would like to use the input parameter to query a secondary datasource and return values to populate part of the form.
For instance I have an inventory control infopath form.
A user on the website has a list of...
Yeah I knew that truncate was minimally logged, and deletes were logged with greater detail.
the database is set to Simple recover mode how much does that affect the deletes vs the truncates?
Thanks
G
George Oakes
CEO & President
COPS Software, Inc.
www.cops2005.com
Programmer & Developer...
Hello all,
we have a SQL database that is populated with data from an Oracle database for website stuff. I did not write the queries that get the data, a former developer wrote them, and we have been having a little troulbe with the transacation logs and some other things. Which is how I got...
never mind I figured it out....
select
dbo.ProperCase(e.drivername) as [DriverName],
Max(m.meterreading) as meterreading,
Sum(f.fuelqty) as fuelqty,
Sum(ftc.milesdriven) as milesdriven ,
(Sum(ftc.milesdriven) / Sum(f.fuelqty)) as MPG,
e.groupid,
e.unitid as [Unit Id],
convert(datetime...
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.