• Locked

Internet Explorer is grabbing browser links

locking this thread as duplicate, please continue at https://support.mozilla.org/en-US/que.../1281053 In recent weeks, clicking on an Outlook email which says "click here… (read more)

locking this thread as duplicate, please continue at https://support.mozilla.org/en-US/que.../1281053

In recent weeks, clicking on an Outlook email which says "click here to view it in a web browser" loads up Internet Explorer. It used to be Firefox which provided the web page. So it looks as though MS IE has infiltrated the computer. How do I clear it out? In Options, Firefox is still listed as the default browser and searching the page produces no hits for Internet Explorer as an add-on etc.

Asked by cvhorie 2 months ago

  • Locked

Will rolling back my update restore my bookmarks?

My software updated "itself" some months ago and ALL my bookmarks disappeared. I tried restoring using a .json file but that didnt work. So will restoring a previous vers… (read more)

My software updated "itself" some months ago and ALL my bookmarks disappeared. I tried restoring using a .json file but that didnt work. So will restoring a previous version get my bookmarks back?

duplicate. continue: https://support.mozilla.org/questions/1281393

Asked by needhelp02 2 months ago

  • Locked

How to sync my log ins?

locking - please continue here - https://support.mozilla.org/en-US/questions/1281329 how to sync firefox services like monitor in @firefox how to sync firefox services li… (read more)

locking - please continue here - https://support.mozilla.org/en-US/questions/1281329

how to sync firefox services like monitor in @firefox how to sync firefox services like monitor in browser and stay signed in after reopening the browser next time? when I exit my FF browser then I am automatically logged out of these sevices but stays signed in on main FF accountbrowser and stay signed in after reopening the browser next time? when I exit my FF browser then I am automatically logged out of these sevices but stays signed in on main FF account

Asked by Aneek 2 months ago

  • Locked

adress bar and bookmarks not working

Started yesterday. no response to bookmarks or address bar. Have done refresh. No change. Attempted reinstall. can't download and save latest version. Therefore reluctant… (read more)

Started yesterday. no response to bookmarks or address bar. Have done refresh. No change. Attempted reinstall. can't download and save latest version. Therefore reluctant to uninstall. No problems with MS Edge. Would going back to a restore point help?

duplicate: https://support.mozilla.org/questions/1281691

Asked by john.mills6 2 months ago

  • Locked

how to copy mail from office outlook to thunderbird

duplicate of https://support.mozilla.org/en-US/questions/1282117 i use outlook from office 365 and want to change to thunderbird. How can I copy all mail to thunderbird f… (read more)

duplicate of https://support.mozilla.org/en-US/questions/1282117

i use outlook from office 365 and want to change to thunderbird. How can I copy all mail to thunderbird from my 6 accounts?

Asked by bert.wissink9 2 months ago

  • Locked

Why can I not log out of twitter or change my profile at all when using it in firefox, despite clearing my data and cache?

[Locked as a duplicate of https://support.mozilla.org/en-US/questions/1282673. Please follow up there, thanks.] I've been having trouble with the functionality of the sit… (read more)

[Locked as a duplicate of https://support.mozilla.org/en-US/questions/1282673. Please follow up there, thanks.]

I've been having trouble with the functionality of the sites twitter and pinterest, twitter especially. There might be other sites affected by whatever this problem is, but twitter is the one I've been messing with the most. Upon logging into twitter, I can post new posts, but I cannot retweet, edit my account, or log off. Clearing my data/cache forces me to log out, but once I log back in, the problem simply returns. I've tried running firefox in safe mode, disabling all my extensions, and even messing with what cookies are allowed through, but all attempts seem ineffective. I've refreshed firefox to default settings and that hasn't worked. These sites are working fine when they're opened in firefox on my mobile device. They work fine when I open them in google chrome on my laptop. It's only firefox, running specifically on my laptop, that is getting this problem. I have no clue what to do at this point.

Asked by Skitty 2 months ago

  • Locked

I get a blank page on FB when I try to go there on my PC but no problem on my android smart phone

When I click on the FB icon it goes to my page but it is blank. I can go there on my android smart phone without a problem duplicated. continue at https://support.mozilla… (read more)

When I click on the FB icon it goes to my page but it is blank. I can go there on my android smart phone without a problem

duplicated. continue at https://support.mozilla.org/en-US/questions/1283094

Asked by 8balllee 2 months ago

  • Locked

can't download from Play Store

duplicate of https://support.mozilla.org/en-US/questions/1283167 Having trouble downloading from Play Store. Nothing happens when I try to update YouTube or update Firefo… (read more)

duplicate of https://support.mozilla.org/en-US/questions/1283167

Having trouble downloading from Play Store. Nothing happens when I try to update YouTube or update Firefox.

Asked by renefromla 1 month ago

  • Locked

Firefox crashes

Question duplicated. Continue at https://support.mozilla.org/en-US/questions/1283685 bp-68678548-283c-46c6-b6c3-0658c0200406 4/5/2020 9:25 PM bp-ae84e06b-fb5d-4d63-832c-6… (read more)

Question duplicated. Continue at https://support.mozilla.org/en-US/questions/1283685

bp-68678548-283c-46c6-b6c3-0658c0200406 4/5/2020 9:25 PM bp-ae84e06b-fb5d-4d63-832c-6a7350200404 4/4/2020 1:24 AM bp-d914610a-de60-4397-b020-7e5d70200321 3/21/2020 3:18 AM bp-3f98246e-de18-4ba1-ae78-451580200320 3/20/2020 3:10 AM bp-6815b058-5698-4c99-9469-854920200302 3/1/2020 9:49 PM bp-f710766b-0469-4145-a922-6c84b0200118 1/17/2020 10:55 PM bp-f1fab83f-ba47-4bd8-a146-018bd0200117 1/16/2020 9:44 PM bp-cf14fc41-e18f-4104-8671-656fa0191222 12/22/2019 2:09 PM bp-08275a02-c1ac-40bd-a883-4be4b0191221 12/21/2019 2:54 PM bp-dc85365f-7e53-4b4e-aae3-e58450191220 12/19/2019 10:00 PM

Asked by gcarlse 1 month ago

  • Locked

i have problem whith google keep site

i have one note from google keep site, which work very very slowly, but google chrome no problem... Замена товаров в операциях UPDATE Operations SET GoodID=292 WHERE Good… (read more)

i have one note from google keep site, which work very very slowly, but google chrome no problem...

Замена товаров в операциях UPDATE Operations SET GoodID=292 WHERE GoodID=251

дубли товаров по алкокоду (каталог 2) SELECT * FROM Goods WHERE Catalog2 In (SELECT Catalog2 FROM Goods WHERE Catalog2 <> AND ID > 1 GROUP BY Catalog2 HAVING COUNT(Catalog2) > 1) ORDER BY Catalog2

дубли партнеров по ФСРАР id (карта) SELECT * FROM partners WHERE CardNumber In (SELECT CardNumber FROM Partners WHERE CardNumber <> AND ID > 1 GROUP BY CardNumber HAVING COUNT(CardNumber) > 1) ORDER BY CardNumber

дубли считанных марок (mssql) SELECT * FROM InternalLog WHERE Message In (SELECT Message FROM InternalLog WHERE Message like '%UTM_%' GROUP BY Message HAVING COUNT(Message ) > 1)

дубли считанных марок (access) SELECT * FROM InternalLog WHERE CStr(Message) LIKE '%UTM_%' AND CStr(Message) In (SELECT CStr(Message) FROM InternalLog WHERE CStr(Message) <> GROUP BY CStr(Message) HAVING COUNT(CStr(Message)) > 1)

Замена товаров в операциях UPDATE Operations SET GoodID='ИД товара который нужно оставить' WHERE GoodID='ИД товара который убираем'

выбор только пивной продукции Select * From goods where Ltrim(Rtrim(substring(goods.catalog3, 178, 15))) in (261,262,263,500,510,520)

select * from goodsgroups where code like 'aab%'

SELECT * FROM Goods WHERE Catalog2 In (SELECT Catalog2 FROM Goods WHERE Catalog2 <> AND ID > 1 GROUP BY Catalog2 HAVING COUNT(Catalog2) > 1) ORDER BY Catalog2

SELECT * FROM Goods WHERE IsNumeric(Barcode1)=0 AND Barcode1<> SELECT * FROM Goods WHERE IsNumeric(Code)=0 AND Code<>

update operations set userrealtime = userrealtime -1 WHERE...

update operations set userrealtime = date + convert(nvarchar(8),userrealtime,114) WHERE ...

А что может быть проще? Insert [ИМЯ НОВОЙ БАЗЫ].[dbo].[partners] ([Code],[Company],[Company2],[MOL],[MOL2],[City],[City2],[Address],[Address2],[Phone],[Phone2],[Fax],[eMail],[TaxNo],[Bulstat],[BankName],[BankCode],[BankAcct],[BankVATName],[BankVATCode],[BankVATAcct],[PriceGroup],[Discount],[Type],[IsVeryUsed],[UserID],[GroupID],[UserRealTime],[Deleted],[CardNumber],[Note1],[Note2],[PaymentDays]) (Select [Code],[Company],[Company2],[MOL],[MOL2],[City],[City2],[Address],[Address2],[Phone],[Phone2],[Fax],[eMail],[TaxNo],[Bulstat],[BankName],[BankCode],[BankAcct],[BankVATName],[BankVATCode],[BankVATAcct],[PriceGroup],[Discount],[Type],[IsVeryUsed],[UserID],[GroupID],[UserRealTime],[Deleted],[CardNumber],[Note1],[Note2],[PaymentDays] from [ИМЯ СТАРОЙ БАЗЫ].[dbo].[Partners])

Server1 - 1000-2499.99 => 4% UPDATE p SET Discount = 4 FROM partners AS p INNER JOIN

   (
       SELECT PartnerID, SUM(Qtty*Sign) AS TurnoverSum
       FROM payments
       WHERE [Mode] = 1
       GROUP BY PartnerID
   ) paym
   ON p.ID = paym.PartnerID

WHERE paym.TurnoverSum >= 1000 AND paym.TurnoverSum < 2500

Server2 - 2500+ => 5% UPDATE p SET Discount = 5 FROM partners AS p INNER JOIN

   (
       SELECT PartnerID, SUM(Qtty*Sign) AS TurnoverSum
       FROM payments
       WHERE [Mode] = 1
       GROUP BY PartnerID
   ) paym
   ON p.ID = paym.PartnerID

WHERE paym.TurnoverSum >= 2500


разные цены

Select * from operations o2 where goodid in (select distinct goodid from operations o left join goods g2 on g2.id = o.goodid where o.Priceout <> g2.priceout2) SELECT * FROM partners WHERE TaxNo = AND CardNumber not like '%050000%' AND CardNumber <>


Александр, вот триггер: USE [vd3] GO /***** Object: Trigger [dbo].[PaymentTypesByUsers] Script Date: 08/14/2017 07:36:40 *****/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO create Trigger [dbo].[PaymentTypesByUsers] ON [dbo].[Payments] AFTER INSERT

AS

IF (SELECT OperType from inserted) = 2 and (SELECT Type from inserted) = 6 and not (select pg.code from inserted left join partners p on inserted.PartnerID=p.id left join PartnersGroups pg on p.groupid=pg.id) like 'AAA%' begin raiserror 100001 'ЗапрещПродажа_Lesop' ROLLBACK TRANSACTION RETURN end IF (SELECT OperType from inserted) = 2 and (SELECT Type from inserted) in (1,2,3,4,5) and (select pg.code from inserted left join partners p on inserted.PartnerID=p.id left join PartnersGroups pg on p.groupid=pg.id) like 'AAA%' begin raiserror 100001 'ЗапрещПродажа_Lesop' ROLLBACK TRANSACTION RETURN end

триггер в Payments на запрет видов оплаты в зависимости от партнера


DELETE FROM ApplicationLog DELETE FROM CashBook DELETE FROM CurrenciesHistory DELETE FROM Documents DELETE FROM ECRReceipts DELETE FROM InternalLog DELETE FROM Lots where id > 1 DELETE FROM Network DELETE FROM NextAcct DELETE FROM Operations Where OperType NOT IN (20,21) DELETE FROM Payments DELETE FROM Transformations DELETE FROM Store

Эту выполнять после всех. DELETE FROM Goods WHERE ID NOT IN (SELECT DISTINCT GoodID FROM Operations)

UPDATE Partners SET Phone2=Phone WHERE NOT Phone=Phone2 AND ID>1 В шедулер

операции без товара: select goodid from operations where goodid > 0 and goodid not in (select distinct id from goods)

DECLARE @CashbookID as int DECLARE @ObjectID as int DECLARE @Acct as int DECLARE Acct_Cursor CURSOR local FOR SELECT ID FROM cashbook where SUBSTRING([Desc],13,10) IN (SELECT DISTINCT Acct FROM payments where opertype = 2) OPEN Acct_Cursor

FETCH NEXT FROM Acct_Cursor into @CashbookID
WHILE @@FETCH_STATUS = 0 
IF @@FETCH_STATUS = 0 
BEGIN
 SET @Acct = (SELECT SUBSTRING([Desc],13,10) FROM cashbook WHERE ID = @CashbookID)
 SET @ObjectID = (SELECT TOP(1) ObjectID FROM payments WHERE acct = @Acct)
 UPDATE cashbook SET ObjectID = @ObjectID WHERE ID = @CashbookID
 FETCH NEXT FROM Acct_Cursor into @CashbookID;
END
ELSE 
 CLOSE Acct_Cursor
 DEALLOCATE Acct_Cursor

Привет! Подскажите пожалуйста, как поправить таблицу CashBook, поле ObjectID? Нужно привести в соответствии с таблицей Operations или Payments. БД MSSQL 2012



дата из примечания

обновит все строки, где в примечании есть слово ЕГАИС

MSSQL:

update operations set date = cast(convert(datetime, SUBSTRING(Note, 7, 10), 104) as date) where note like 'ЕГАИС%' and opertype = 1

ACCESS:

________________

it isn't all

v.s. -->

Asked by 5978156 1 month ago