Hi George
The resulting table is correct.
The reason the value for DISC_COD is null for ITEM_NO 1003 in the resulting table is because it was null in the first place.
Regards,
Georges
Hi Skip
I have always thanked members with a formal reply who have responded to my questions in which they have been helpful. It is many more times than once.
In several cases, I did not get a helpful response in time and I had to find an alternative solution. In those cases where the...
Hello
I would like to update the column in one table based on the results of a query from another table.
I have two tables IM_ITEM and IM_INV tables. In the IM_INV table I would like to sum up the location quantities for each item. If the quantity is zero, I would like to set the...
...run the command with the REPAIR_ALLOW_DATA_LOSS, the same error occurs:
DBCC CHECKDB(BHT, REPAIR_ALLOW_DATA_LOSS)
Running the command
select *
from pduser.PDCPS_DOC_LIN
where CDOC_ID in (101321732044, 101321732866, 101321734503, 101321735658)
gives the result:
CDOC_ID...
Hello kmcferrin
The node type is the same on all computers and is set to Hybrid. WINS is not enabled on any of the computers. Also GlobalNames Zones are not used.
Hello kmcferrin
All the computers and NAS are on the same subnet. I know I could add the netbios name in the lmhost file of the Windows 2008 server but I wanted an explanation as to why only this server behaves differently than all the other servers and computers on the same network. We...
Hi joepc
This solution does not help. Also, as I mentioned above, we do not have a problem mapping the share using the IP address in the UNC path. The problem we have is mapping the share using the NETBIOS name.
Also, the problem is not domain wide. It is only with one particular...
Hi joepc
This solution does not help. Also, as I mentioned above, we do not have a problem mapping the share using the IP address in the UNC path. The problem we have is mapping the share using the NETBIOS name.
Also, the problem is not domain wide. It is only with one particular...
Hi
When I run ping -a on the IP address of the QNAP I get the hostname.
When I run nslookup in interactive mode, I get the following:
Default Server: Unknown
Address: ::1
Hello
We have a Windows Server 2008 R2 that is NOT able to open a share on a NAS using its NETBIOS name. However it CAN open it using the IP address. The NAS and the Windows Server 2008 are both joined to a Windows 2008 domain.
There are other computers on the network that are part of the...
Hi,
But I cannot connect even via the LAN and the firewall is disabled on the server? I am the administrator of the network and I did not stop remote access on the server.
Hello
I use to be able to connect via Windows VPN to my Windows 2003 Server but something has happened and I can no longer connect.
I am trying to make a VPN connection from a Windows XP Pro client on the local LAN (to take our firewall out of the picture) but I keep getting the error...
Hello
I use to be able to connect via Windows VPN to my Windows 2003 Server but something has happened and I can no longer connect.
I am trying to make a VPN connection from a Windows XP Pro client on the local LAN (to take our firewall out of the picture) but I keep getting the error...
Hi
No I do not mean the disk label. If you go under the device manager under Disk Drives, you will see the Device Friendly Name. I want to be able to change that friendly name.
Hi,
Is there a way to modify the manufacturer friendly name for an external USB Seagate Freeagent Go drive?
The reason we need to do this is that we are using VMware workstation which requires you to disconnect the external usb drives from the menu when removing them from the guest OS...
Hi LB
My report works. I just read about SQL Expressions and wanted to know if I could improve my report performance by using them. The concept of using SQL statements so that the server is able to handle some of the processing by reducing the number of records that the client works with...
My report is taking too long and I want to use a SQL Expression so that the server will only pass the records needed for my crystal report.
The problem is that I am not sure if SQL Expressions are designed for reports that are not accessing SQL databases directly. We need to access a...
BTW,
In regards to what I have tried before, the answer is not much since I really do not have any documentation on how to work with use the SQL Epxressions Field with a Pervasive.SQL database.
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.