Search results for query: *

I need to convert the following data into a number. It is from a mainframe using a standard TSO app. The data represents a $ amount with 2 decimals but comes thrugh as the following: 0000007288D 0000007288M 0000007288D 0000024553{ If anyone can advise I would be grateful TIA, Stan Remember -...

I have the above referenced app and it does a strange thing. I can open the app and get and send mail but it will not close propperly and I must reboot to get it to clear from memory. Ctl-Alt-Del does not show the app running but it appears in my sys tray. I am using XP Pro SP2 in a home office...

I just replaced a power supply on a Compaq S5200 computer (350W that is compatible with the unit I replaced) and now when I plug the PC in and try to turn it on I get a power active indication (lights are on and CPU fan is running) and then the power just goes off. Anybody have any ideas on the...

HI, I am trying to process on dates from a VFP 7 data file that we used to use to compare with the new SQL platform we are currently moving into. My problem is the date field from VFP is coming into Excel as a text field yyyymmdd and I can't seem to reformat it. Can anyone help me with this...

Hi, I need to convert a date from an SQL table datetime to an ascii numeric MMDDYY field. When I run the query I reformat the date to read as MMDDYY by removing the separators and assigning the correct output form. My problem is I get a result that catches the space where the separator would be...

I am trying to connect to my PC in the officethru remote access. Office server is W2K3 and office PC is on XP. I have a port address to search but when I try to connect using IE6 I get a syntax error. My firewall is programmed to allow me to pass thru it but to no avail. I am running Win98SE at...

I am new in the MS SQL world and am curious re what a source is in a system log? I see a process open database tagged to spid12 and then the next process open data base tagged to spid13. Can anyone resolve my curiosity as to what this log is telling me? 2004-01-03 16:53:47.89 spid12 Starting...

cvan someone guide a blind accountant thru the process of building a cube in SQL 2K. I can't seem to figure out where the tree pane that the help topics point me to are. I am probably in the wrong part of the app. Any help would be appreciated. stan Remember - only dead fish go with the flow.

Hi, I'm trying to create an sql environment on my office PC whiuch is connected to a server. I want to learn SQL access issues before I start the actual system on an SQL 2K server. I have received a Personal SQL disk with the main system disk and am curious if this will resolve my immediate...

I am searching for a solution for our trucking company. We have approximately 100 employees currently and 80 are drivers. We currently are operating on a VFP platform that is poor in performance and is a bear to use for the dispatch and clerical desks. I have been researching various options...

I am facing a decision re our IT direction in the comapny. We are a medium sized trucking comapany near the Canadian border. We are currently running NT 4 server and 8 workstations to support our fleet of 70 tractors. We hauls approximately 500 loads a week and generate about 300 invoices per...

Good morning, Is there a way to add a blank record to the end of a report that will create a record that the receiving parties system will then discard as a control record. I send a data report to a company that requires a control record at the end of the file (last record) and it then ignores...

Can someone please advise on the JOIN capability of data driller. I need to link several tables and for the life of me can only add one to the query generator. Any help would be greatly appreciated. thanks, stan Remember - only dead fish go with the flow.

Is there a way to get a map or listing of tables and how those tables are related? I am working with a trucking app and need to at least output table structure out so I can try to build the map myself. The DBF are not normalized and ideally I would like to try and accomplish this as an...

I am tweaking a service bureau report for customer billing activity. The report requires a shipper name, a consignee name and a bill to name. I am able to get info for consignee and bill to customers but one time shippers are tagged as a MISC shipper and have no name attached to the record. When...

Can I attach an index file to a report? need to see info on three data fields in an invoice: Customer Name (CUSTNO) Consignee Name (CONNO) Shipper Name (SHIPNO) all 3 are indexed to CUSTMSTR.CUSTNO. I have tried creating three aliases of CUSTMSTR and link that way but the app developer is...

I have 2 DBF files that have exactly the same structure and indexing. One file is historic and the other is current. The only difference between the 2 is current has activity that is for unclosed periods or an invoice is still in unpaid status. Can combine these 2 files in a report writer...

I am trying to create a report that mimics a service bureaus data input form. I am using VFP V7 DBF tables FRMAST and FRTRAN. the tables are related via INVNO field. The FRMAST file looks like this: INVNO invoice number CUSTNO customer number TRANSDATE transaction date...

Can someone help me with syntax on Calendar1stQtr etc function. I lost my manual. thanx, stan

I would like to know if there is a way to gain remote access to an NT 4.0 file server from home via the web. Server is connected via DSL and my connection is via cable. We are currently using remote control software PC Anywhere) but this is cumbersome and leaves the system vulnerable. I would...