Search results for query: *

It's not my website - thanks anyway. I'll just execute code.

Yes, I should create a foreign key but I don't see anywhere to do that on phpmyadmin.

Hi there, I'm creating a very simple database in phpmyadmin. How do I assign a possible value list to a field in a table? The PV list is an indexed field in a different table. I can't figure out how to do it in phpmyadmin. Thanks for your help. Dolores

Thanks guys - that works!

Thanks very much!

Hi, I'm trying to insert a carriage return into the following string function but it still returns all the records on the same line: SELECT @str = COALESCE(@str + char(13),'') + '$' + CAST ( t2.stotalAmount AS VARCHAR) + ' for ' + CAST( rtrim(t2.snotes) AS...

Hi, I'd like to combine the results from this UNION ALL: select pr.hmy, count(pm.hmy) from pmuserex pm inner join property pr on pr.hmy = pm.hproperty inner join person p on p.hmy = pm.hobjpointer inner join room r on r.hmyperson = pm.hobjpointer where pr.hmy = 510 group by pr.hmy UNION ALL...

Thank you!

Thanks so much!

Hi, I need help with conventions on turning a script into a stored procedure. here's the script: /* Version 1.0 DESCRIPTION Create Temporary Tables for Updating Minimum and Maximum Rent on Floorplan table Created by d.meehan 4/23/2010 */ if exists (select * from dbo.sysobjects...

Tahnks so much!

Hi Guys, I need help with the following statement. I am trying to delete records in one table (unitbut_amenity) based on a value in a joined table (unit): delete from unitbut_amenity inner join (select u.hproperty hproperty, u.hmy hunit from unit u) as main on main.hunit =...

Thanks mucho!

I’m trying to run the following script and get an error (see below): select ach.hperson, ach.sname, ach.sacct, ach.bportal, ach.hroommate FROM (select hperson, count(hmy), brecur from achdata where brecur <> 0 group by hperson, brecur having count(hmy) > 1) main inner join achdata ach on...

Hi, How can I set ANSI_DEFAULTs to ON in a report script in SQL Server. Here is the select statement: SELECT t.sfirstname, t.slastname, ts.status, pm.susercode, pm.susertype, pr.scode FROM pmuserex pm INNER JOIN [jqnnbla_sandbox_2k5].jqnnbla_sandbox_2k5.dbo.tenant t on t.hmyperson =...

Thanks, it works now!!!!

Thanks - I am still getting an error - Incorrect syntax near 'm'. Any thoughts? select m.thmy, t.hmy, t.uref uref, t.upostdate postmonth, a.scode acct, p.scode property, d.samount amt, j.scode job, t.snotes notes FROM (select t.upostdate postmonth, d.hprop prop, d.hinvorrec thmy...

Hi, I am trying to run a query that will first select a set of data based on one criteria and then select another set of data based on the results of that query. Here's my attempt - I know I'm mising something - thanks for your help. select main.thmy, t.uref uref, t.upostdate postmonth...

Thanks All, It turns out that it will open once Access is open but not from Explorer - strange quirk. Again thanks all for your help! Dolores

Hi, Thanks for your reply. We are not using user level security - it's a nightmare. When the DB is open, no one else can open it. You click on it and nothing happens. I am having the folder containing the DB shared specifically. I'll see how that works. Again thanks for your prompt reply...